Re: Procedure that select different number of columns
>> how about writing a query that returns to application env table?
>I don't understand that question.
For my app I need other stuff then just parameters and item id's ;) so this query should return also other stuff at once e. g.
item 1 name; number of items; when added; OTHER STAFF ; parameter 1 name; parameter val
item 1 name; number of items; when added; OTHER STAFF ; parameter 2 name; parameter val
item 1 name; number of items; when added; OTHER STAFF ; parameter 3 name; parameter val
item 2 name; number of items; when added; OTHER STAFF ; parameter 1 name; parameter val
...
This have a lot of unneeded data (repetition first x cols) but I don't need to make a pivot table, and I don't need to get rid of EAV table when doing something like this, and I have all needed data in single query.
Subject
Views
Written By
Posted
2745
October 15, 2013 01:45PM
1266
October 15, 2013 03:47PM
1133
October 16, 2013 12:05AM
1144
October 16, 2013 09:25AM
1142
October 20, 2013 11:18AM
1206
October 20, 2013 03:24PM
1145
October 20, 2013 04:09PM
1121
October 21, 2013 12:31AM
1093
October 21, 2013 09:10PM
Re: Procedure that select different number of columns
1236
October 21, 2013 11:56PM
1098
October 22, 2013 12:08AM
1843
October 22, 2013 07:24AM
1160
October 22, 2013 09:19AM
1241
October 23, 2013 12:10PM
1106
October 23, 2013 06:23PM
2188
November 08, 2013 04:57PM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.