OraFAQ Forum: SQL & PL/SQL » SELECT with variables

Home » SQL & PL/SQL » SQL & PL/SQL » SELECT with variables

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

SELECT with variables [message #36018]

Tue, 30 October 2001 06:33

Steve Laliberte
Messages: 1
Registered: October 2001

Junior Member

I don't know if this can be done but i want to perform a SELECT where the field name and the table name are stored in variables.

Exemple :

xTableName VARCHAR2(25);
xFieldName VARCHAR2(7);
xValue VARCHAR2(15);

SELECT xFieldName INTO xValue FROM xTableName

Can this be done ? and how ?

I get errors when i compile.

Thanks !!

----------------------------------------------------------------------

Report message to a moderator

Re: SELECT with variables [message #36023 is a reply to message #36018]

Tue, 30 October 2001 07:19

Todd Barry
Messages: 4819
Registered: August 2001

Senior Member

If you are running 8i or later, you can use dynamic native SQL (otherwise you'll need to use DBMS_SQL).

execute immediate 'select ' || xFieldName || ' from ' || xTableName into xValue;

----------------------------------------------------------------------

Report message to a moderator

Previous Topic:	date format
Next Topic:	execute immediate issue - updated

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed Dec 25 10:50:26 CST 2024