Select column at runtime

[ilikesuresh]

hi
i have a table (table_Days)tha t contains columns
d0 d1 d2 d3 ............... d30

based on my result i want to either select d0 or d1 or d3 ....d30 at runtime and get the respected value on that column
plz any one can help me out!!!!!!

[debasisdas]

that can be eaily done by writing a simple PL/SQL block.

[nramrits]

hi
i have a table (table_Days)tha t contains columns
d0 d1 d2 d3 ............... d30

based on my result i want to either select d0 or d1 or d3 ....d30 at runtime and get the respected value on that column
plz any one can help me out!!!!!!

select * from table_days where &column_name=&a rgument

[amitpatel66]

You can accomplish this task easily by using a Simple PLSQL block or using a DECODE, CASE statement in the SQL query itself.

[ilikesuresh]

You can accomplish this task easily by using a Simple PLSQL block or using a DECODE, CASE statement in the SQL query itself.

Thanks for your guidelines