Home » SQL & PL/SQL » SQL & PL/SQL » using variable in a query
using variable in a query [message #224401] Wed, 14 March 2007 03:10 Go to next message
udhu
Messages: 1
Registered: March 2007
Junior Member
hii there,
I need to use a variable (whose value is obtained at runtime and not through command prompt) in a simple query.
For eg.
select TABLE_NAME from set;
where TABLE_NAME is a variable.
Suggest me on how to write a query which takes TABLE_NAME as an variable and not as a column name. (This variable's value is decided by another procedure not from command prompt)

Report message to a moderator

Re: using variable in a query [message #224406 is a reply to message #224401] Wed, 14 March 2007 03:21 Go to previous message
aciolac
Messages: 242
Registered: February 2006
Senior Member
The solution is to use dynamic SQL.

Report message to a moderator

Previous Topic: CAST and Multiset options in oracle
Next Topic: SQL-SPOOL
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Dec 06 18:04:55 CST 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.