Select column data by pasing in column name

[mcgibbong]

I am writing a function that accepts the column name from all_tab_columns for any table and select the column data using this name. eg get the column name account_number which i know is in the accounts table, from all_tab_columns. I then want to select account_number from accounts. If I just pick up the column name account_number from all_tab_columns , and do select i'll get the text account_number. I need a way of getting 'contents of filed named'account_number into the select.

Long explanation, hopefully short answer.

 

[sem]

Use dynamic sql (REF CURSOR).

Regards, Dima

http://seminihin.narod.ru