Deprecated SQL*Plus Commands in Oracle 11g R2

This just a short note to point out that the below SQL*Plus commands are deprecated as of Oracle 11g R2, but available in the current release of SQL*Plus for backward compatibility. The documentation states that this may only be available by setting the SQLPLUSCOMPATIBILITY variable in the future releases.  You should modify scripts using obsolete commands to use the alternative commands.

  • BTITLE (old form)
  • COLUMN DEFAULT
  • DOCUMENT
  • NEWPAGE
  • SET BUFFER
  • SET COMPATIBILITY
  • SET CLOSECURSOR
  • SET DOCUMENT
  • SET MAXDATA
  • SET SCAN
  • SET SPACE
  • SET TRUNCATE
  • SHOW LABEL
  • TTITLE (old form)

Leave a Comment

Your email address will not be published. Required fields are marked *

Time limit is exhausted. Please reload the CAPTCHA.