Name
SET COMPATIBILITY
Synopsis
The COMPATIBILITY setting tells SQL*Plus the version of Oracle to which you are connected.
Syntax
SET COM[PATIBILITY] {V7 | V8 | NATIVE}Parameters
- SET COM[PATIBILITY]
Is the command, which may be abbreviated SET COM.
- V7
Tells SQL*Plus you are connected to a Version 7 server or that you want SQL*Plus to act as if you were.
- V8
Tells SQL*Plus that you are connected to a Version 8 database.
- NATIVE
Causes SQL*Plus to automatically determine the compatibility setting based on the version of the database to which you are connected. This is the default setting.
This setting controls the way that SQL statements are transmitted to the server and the way that the results are brought back. It's usually best to leave this at the default, which causes SQL*Plus to choose the correct method automatically based on the database to which you are connected.
Get Oracle SQL*Plus: The Definitive Guide, 2nd Edition now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
