what is dbms_sql [message #1711] |
Thu, 23 May 2002 14:11 |
pavani
Messages: 32 Registered: April 2002
|
Member |
|
|
what is dbms_sql what does it mean ,what for it is used
let me know this plzz.
|
|
|
Re: what is dbms_sql [message #1721 is a reply to message #1711] |
Fri, 24 May 2002 02:29 |
|
Maaher
Messages: 7065 Registered: December 2001
|
Senior Member |
|
|
DBMS_SQL is an Oracle provided database package that enables the usage of Dynamic SQL in PL/SQL program units.
Oracle 8i or higher provide a more efficient and transparent way to use dynamic SQL though:
EXECUTE IMMEDIATE _sql_string_;
MHE
|
|
|