Home » SQL & PL/SQL » SQL & PL/SQL » what is dbms_sql
what is dbms_sql [message #1711] Thu, 23 May 2002 14:11 Go to next message
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 Go to previous message
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
Previous Topic: How do I select the LAST RECORD of the Table?
Next Topic: Dynamic Sql
Goto Forum:
  


Current Time: Fri Apr 19 00:36:57 CDT 2024