Home » SQL & PL/SQL » SQL & PL/SQL » DYNAMIC SQL
DYNAMIC SQL [message #19891] Tue, 16 April 2002 23:41 Go to next message
Prads
Messages: 5
Registered: April 2002
Junior Member
Hi all,

Guys, I was asked this question in an interview, and i didn't knew the answer, I had never heard about it. If anyone knows then please tell me.

What is DYNAMIC SQL method 4?

Thanks,
Prads
Re: DYNAMIC SQL [message #19893 is a reply to message #19891] Wed, 17 April 2002 00:15 Go to previous messageGo to next message
seng
Messages: 191
Registered: February 2002
Senior Member
Just know the Dynamic SQL only, The Dymamic SQL is using dbms_sql(packages) to call query language. This Dynamic SQL is using in procedure/function. Use this Dynamic SQL, then DDL/DML can call in procedure/function.

I don't know the method 4 . hope this is helping.
Re: DYNAMIC SQL [message #19897 is a reply to message #19891] Wed, 17 April 2002 03:35 Go to previous message
hanu
Messages: 21
Registered: March 2002
Junior Member
Check the link for more information:

http://download-west.oracle.com/otndoc/oracle9i/901_doc/appdev.901/a89861/pc_15ody.htm#4491
Previous Topic: question
Next Topic: date comparison
Goto Forum:
  


Current Time: Mon May 06 18:35:24 CDT 2024