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: 65143
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: how to create dynamic spool
Next Topic: Is tuning needed for this SQL ?
Goto Forum:
  


Current Time: Sat Aug 19 08:14:14 CDT 2017

Total time taken to generate the page: 0.05536 seconds