Author: codertutor_3o6d0o

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...

Connect As Sysdba Syntax: CONNECT “username/password@connect_string AS SYSDBA” CONNECT / AS SYSDBA Starting SQL*Plus: SQLPLUS [option] “username/password@connect_string AS SYSDBA” Examples: SQL> sqlplus SQL> connect “system/user” SQL> sqlplus “sys/user AS SYSDBA”...