| sql-pl/sql help needed urgent [message #35671] |
Thu, 04 October 2001 16:23  |
Bj
Messages: 8
Registered: March 1999
|
Junior Member |
|
|
can i pass a column as a parameter in a select statement Oracle 8.0.6 version
for eg : select v_name from table_name
Here v_name is a variable which will contain my column name
Is it possible without using dynamic sql
What I want to do is this :
I know a table name and at runtime I get the column name for the table from all_tab_columns
and then at runtime i also need to get the values for the column for rownum =1
Is the problem clear
----------------------------------------------------------------------
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
