Home » SQL & PL/SQL » SQL & PL/SQL » Dynamic Sql (Oracle 10g)
Dynamic Sql [message #342366] Fri, 22 August 2008 02:50 Go to next message
Messages: 98
Registered: July 2007
Location: pune
Dear All,
Am having a table called Gen_Template.
Create Table Gen_Template( variable_name Varchar2(100) , Data_type Varchar2(100));
Table's data
variable_name Data_type
v_age Number
v_address Varchar2(100)

In my procedure i will check one condition.If that conditions
passes then i need to store some value on the variable v_age
and vice versa.How to do that?
Re: Dynamic Sql [message #342371 is a reply to message #342366] Fri, 22 August 2008 02:59 Go to previous message
Michel Cadot
Messages: 63935
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Why not using just a SQL statement?

Previous Topic: Bulk Insert
Next Topic: Utl Mail
Goto Forum:

Current Time: Thu Oct 27 12:00:38 CDT 2016

Total time taken to generate the page: 0.07706 seconds