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
sundarfaq
Messages: 235
Registered: October 2007
Location: Chennai
Senior Member
Hi,
what is the purpose of DBMS_SQL.NATIVE clause?

Thanks,
Michael
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: 64151
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
From doc:
Quote:
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.


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


Current Time: Fri Dec 09 13:42:29 CST 2016

Total time taken to generate the page: 0.10138 seconds