Home » SQL & PL/SQL » SQL & PL/SQL » dbms_sql.native (oracle,9i,Linux)
dbms_sql.native [message #311881] Mon, 07 April 2008 04:29 Go to next message
Messages: 235
Registered: October 2007
Location: Chennai
Senior Member
what is the purpose of DBMS_SQL.NATIVE clause?

Re: dbms_sql.native [message #311896 is a reply to message #311881] Mon, 07 April 2008 05:32 Go to previous message
Michel Cadot
Messages: 64961
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
From doc:
language_flag: Determines how Oracle handles the SQL statement. The following options are recognized:

  • V6 (or 0) specifies version 6 behavior.
  • NATIVE (or 1) specifies normal behavior for the database to which the program is connected.
  • V7 (or 2) specifies Oracle database version 7 behavior.

Previous Topic: Using ANSI joins
Next Topic: use of union with case
Goto Forum:

Current Time: Tue Jun 27 21:17:00 CDT 2017

Total time taken to generate the page: 0.15831 seconds