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...
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: 65152
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
You can't, you have to use dynamic SQL, "execute immediate" or dbms_sql package.

Regards
Michel
Previous Topic: Bulk INsert
Next Topic: Trigger-summing values
Goto Forum:
  


Current Time: Tue Aug 22 04:19:31 CDT 2017

Total time taken to generate the page: 0.02434 seconds