Category: SQLPlus

ATTRIBUTE Command Syntax: ATTRIBUTE [type_name.attribute_name [option …]] option can be one of the clauses: ALI[AS] alias CLE[AR] FOR[MAT] format LIKE {type_name.attribute_name|alias} ON|OFF ATTRIBUTE Command Examples: ATTRIBUTE CUSTOMER_TYPE.NAME FORMAT A20 ATTRIBUTE CUSTOMER_TYPE.AMOUNT FORMAT $9,999,990.99...

ARCHIVE LOG Command Syntax: ARCHIVE LOG {LIST|STOP}|{START|NEXT|ALL|integer } [TO destination] ARCHIVE LOG Command Examples: ARCHIVE LOG list ARCHIVE LOG stop ARCHIVE LOG start ARCHIVE LOG next ARCHIVE LOG all ARCHIVE LOG n ARCHIVE LOG START – Used to start up the...

APPEND Command Syntax: A[PPEND] text Insert data into an existing file / table, or creates a new file / table if it’s not already present. APPEND Command Examples: SQL> save c:\docs\file.sql append Appended file to c:\docs\file.sql...

The ACCEPT command reads a line of input and stores it in a given user variable. ACCEPT Command Syntax: ACC[EPT] variable [NUM[BER]|CHAR|DATE] [FOR[MAT] format] [DEF[AULT] default] [PROMPT text|NOPR[OMPT]] [HIDE] ACCEPT Command Examples: ACCEPT pswd CHAR PROMPT ‘Password: ‘ HIDE ACCEPT amount...

EDIT Command syntax: ED[IT] [file[.ext]] file – file that you want to edit Example: SQL> edit sql_file.sql...