Last post Sep 30, 2013 08:50 AM by George_DSOftZA
Sep 25, 2013 03:46 AM|George_DSOftZA|LINK
First of all I really hope that i am at the right place for my query as this is my first post. I am using Oracle 10g along with Visual Studio 2010.
I have an Oracle table named Segment_Restriction with 'all the columns as integer' as shown below:
Now if you can see the row where Segment_ID is 0, i.e, first row, this is taken as a base row.
Now if suppose i say that i want the row with segment_ID = 14
So i get the following:
Here comes my question...
Now, further in this row, i need to find the column names of columns having values = 1 and also the first row value of that column (column value with 0 segment id).
So in this example, i should get segment_h2 as the column name and 15 as the first row contains 15 for segment_h2.
How do I do this. I hope my question is clear...
I need help as early as possible. I am finding this complicated and need this on urgent basis as my clients need this logic done by evening.
Please reply at the earliest.
Sep 25, 2013 05:32 AM|George_DSOftZA|LINK
Please reply soon. Help needed urgently on this.
Sep 25, 2013 02:31 PM|George_DSOftZA|LINK
Guys! I need some advice atleast on this... PLease Please Please reply someone...
Sep 25, 2013 07:57 PM|Lannie|LINK
Step 1: It will be easier to use Oracle Analytics if you first normalize your table into this layout (either as new table or view):
Sep 26, 2013 08:23 AM|George_DSOftZA|LINK
Thanks for the suggestion... Would put it accross my team. Lets see what they. I really appreciate your reply. Thanks again Lannie... :)
Sep 30, 2013 08:50 AM|George_DSOftZA|LINK
Did not exactly use your suggestion. But got a hint to do it. Temporarily working it out by looping the datatables... Would get this working as a permanant solution. Thanks Lannie for your help...