Home » SQL & PL/SQL » SQL & PL/SQL » sql-pl/sql help needed urgent
sql-pl/sql help needed urgent [message #35671] Thu, 04 October 2001 16:23 Go to next message
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

----------------------------------------------------------------------
Re: sql-pl/sql help needed urgent [message #35673 is a reply to message #35671] Thu, 04 October 2001 17:51 Go to previous messageGo to next message
Todd Barry
Messages: 4819
Registered: August 2001
Senior Member
You can still use dynamic SQL (DBMS_SQL) in 8.0.6, just not native dynamic SQL (execute immediate).

----------------------------------------------------------------------
Re: sql-pl/sql help needed urgent [message #35675 is a reply to message #35671] Thu, 04 October 2001 18:36 Go to previous message
Bj
Messages: 8
Registered: March 1999
Junior Member
Thanks

----------------------------------------------------------------------
Previous Topic: DBMS_TCP and DBMS_SMTP packages
Next Topic: Group function not allowed in a cursor?
Goto Forum:
  


Current Time: Fri Mar 29 10:29:15 CDT 2024