database - How to create a temporary / dynamic / virtual table when a SQL runs in Oracle? -

-

i have data has measured not in table. can not insert table nor can create table , insert these data. used dual following table. used join other tables.

with movie_genre ( select '10' "id", 'action' "genre" dual union select '20' "id", 'horror' "genre" dual union select '30' "id", 'comedy' "genre" dual union select '40' "id", 'adventure' "genre" dual union select '50' "id", 'drama' "genre" dual union select '60' "id", 'mystery' "genre" dual union select '70' "id", 'musical' "genre" dual ) select * movie_genre ;

so result -

id  genre 10  action 20  horror 30  comedy 40  adventure 50  drama 60  mystery 70  musical

my question is, there better way this? suggestion life saver.

an example -

lets have table -

create table movies ( id number, name varchar2(50), genre_id number );  insert movies values (1, 'the hulk', 10); insert movies values (2, 'dumb , dumber', 30); insert movies values (3, 'frozen', 70);

and need result -

name                genre        is_in_genre hulk            action       yes hulk            horror       no hulk            comedy       no hulk            adventure    no hulk            drama        no hulk            mystery      no hulk            musical      no dumb , dumber     action       no dumb , dumber     horror       no dumb , dumber     comedy       yes dumb , dumber     adventure    no dumb , dumber     drama        no dumb , dumber     mystery      no dumb , dumber     musical      no frozen              action       no frozen              horror       no frozen              comedy       no frozen              adventure    no frozen              drama        no frozen              mystery      no frozen              musical      yes

here, not have movie_genre table.

you can pass genre string in order want , use regular expression generate movie_genre table.the sql fiddle here

with movie_genre (   select level * 10 id, regexp_substr(genre,'[^,]+',1,level) genre   (   select ('action,horror,comedy,adventure,drama,mystery,musical')    genre dual   )   connect level <=regexp_count(genre,'[^,]+')  )  select * movie_genre;

Comments

Post a Comment

Popular posts from this blog

google chrome - Developer tools - How to inspect the elements which are added momentarily (by JQuery)? -

-
i looking @ how website designed using inspector in chrome. can use firefox developer tools or firefox web developer add-on or chrome web developer extension. so website has slide-show , using jquery it. looking @ markup , css in inspector, i see 2 things constantly changing slides change: one opacity css property understandable, i'd see changing values, changes fast see read anything. second- a div added in div slides change momentarily , moment when appears short notice except div . so question is there way stop slideshow can temporarily rid of blinking sort of effect (by speedy adding , removal , changing of elements , values)? where can inspect div element gets added such short moment , , gets removed? , can see changes in value of opacity takes place? is there way stop slideshow can temporarily rid of blinking sort of effect (by speedy adding , removal , changing of elements , values)? if opacity animated css transition or animation,
Read more

angularjs - Showing an empty as first option in select tag -

-
my app showing empty select field first entry. have read other solution given , tried still not working. my controller code is: .controller('usercreatecontroller', function(user,profile,auth) { alert("hello"); var vm = this; vm.type = 'create'; profile.all() //this service fetch profiles shown in select field .success(function(data){ vm.profile = data; }); vm.userdata.profile = vm.profile[0]; //here have set default value select field and html page is: <label class="col-sm-2 control-label">profile</label> <div class="col-sm-8"> <select ng-model="user.userdata.profile" ng-options="person._id person.profilename person in user.profile"> </select> </div> hierarchy of vm.profile { "_id": 46, "profile": objectid("5516498e95b84548156db754"), "isactive": true, "password": "$2
Read more

php - Cloud9 cloud IDE and CakePHP -

-
i attempting cakephp running on cloud9, cloud based ide. unaware, cloud collaboration ide intermixes services such bitbucket. site gives sudo rights, , installed cakephp using these instructions: https://www.digitalocean.com/community/tutorials/how-to-install-cakephp-on-an-ubuntu-12-04-vps when attempt run database exported machine cakephp installed, error message "url rewriting not configured on server." attempted solve issue using official guide cakephp: http://book.cakephp.org/2.0/en/installation/url-rewriting.html but no cigar, same error message. has gotten cakephp working, or aware of cloud ide free/low cost cloud9 support cakephp? here's how got working now: sudo apt-get update sudo apt-get install php5-intl curl -ss https://getcomposer.org/installer | php -- --filename=composer ./composer create-project --prefer-dist cakephp/app this creates project in /app default. move workspace docroot: mv app/* ./ mv app/.* ./ rm -rf app then de
Read more