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
subbu_tce
Messages: 98
Registered: July 2007
Location: pune
Karma: 0
Member
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: 65153
Registered: March 2007
Location: Nanterre, France, http://...
Karma: 0
Senior Member
Account Moderator
Why not using just a SQL statement?

Regards
Michel
Previous Topic: grouping function
Next Topic: what is BYPASS_UJVC? in update statement
Goto Forum:
  


Current Time: Tue Aug 22 13:50:30 CDT 2017

Total time taken to generate the page: 0.13177 seconds