Change SQL*Plus System Settings in Oracle

Q

How To Change SQL*Plus System Settings in Oracle?

✍: FYIcenter.com

A

SQL*Plus environment is controlled a big list of SQL*Plus system settings. You can change them by using the SET command as shown in the following list:

  • SET AUTOCOMMIT OFF - Turns off the auto-commit feature.
  • SET FEEDBACK OFF - Stops displaying the "27 rows selected." message at the end of the query output.
  • SET HEADING OFF - Stops displaying the header line of the query output.
  • SET LINESIZE 256 - Sets the number of characters per line when displaying the query output.
  • SET NEWPAGE 2 - Sets 2 blank lines to be displayed on each page of the query output.
  • SET NEWPAGE NONE - Sets for no blank lines to be displayed on each page of the query output.
  • SET NULL 'null' - Asks SQL*Plus to display 'null' for columns that have null values in the query output.
  • SET PAGESIZE 60 - Sets the number of lines per page when displaying the query output.
  • SET TIMING ON - Asks SQL*Plus to display the command execution timing data.
  • SET WRAP OFF - Turns off the wrapping feature when displaying query output.

 

Show Current SQL*Plus System Settings in Oracle

Run PL/SQL Statements in SQL*Plus in Oracle

Introduction to Command-Line SQL*Plus Client Tool

⇑⇑ Oracle Database Tutorials

2020-07-22, 2318🔥, 0💬