SQL Plus - Tab System variable

Card Puncher Data Processing

About

Tab is a system variable that setermines how SQL*Plus formats white space in terminal output.

Syntax

SET TAB {ON | OFF} 

where:

  • ON uses the TAB character. TAB settings are every eight characters. The default value for TAB is system dependent.
  • OFF uses spaces to format white space in the output.





Discover More
Card Puncher Data Processing
SQL Plus - Formatting Reports

How to format SQLplus output (ie ) All below parameters can be configured in the login script. Through the SQLPlus COLUMN command with the heading options, you can change the column headings...
Card Puncher Data Processing
SQL Plus - System Variable (Configuration)

System Variables Description APPI[NFO]{ON | OFF | text} Sets automatic registering of scripts through the DBMS_APPLICATION_INFO package. arraysize Sets the number of rows, called a batch, that SQLPlus...



Share this page:
Follow us:
Task Runner