Home » SQL & PL/SQL » SQL & PL/SQL » store table name in a variable (forms 10g)
store table name in a variable [message #359933] Tue, 18 November 2008 21:27 Go to next message
masterborj
Messages: 21
Registered: October 2007
Location: Philippines
Junior Member
to simplify thing how can i use a variable instead of a the table name in a FROM clause in a query.
I use the same query on five different table. For me to shorten my codes, I will just store the table name in a variable.
By the way I use FORMS 10g and the codes where in a WHEN-LIST-CHANGED trigger.Thanks...

Report message to a moderator

Re: store table name in a variable [message #359952 is a reply to message #359933] Tue, 18 November 2008 23:22 Go to previous message
Michel Cadot
Messages: 68737
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
You can't, you have to use dynamic SQL, "execute immediate" or dbms_sql package.

Regards
Michel

Report message to a moderator

Previous Topic: positional notation and rownum
Next Topic: Getting wrong type of arguments
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Mon Feb 17 22:27:39 CST 2025
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.