Category: SQLPlus

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

To specify options for working with SQL * Plus it is use the command SET. The most important SQL * Plus SET Commands SET ECHO {ON|OFF} lists each command in a script as the command is executed. SET FEED[BACK] {6|n|ON|OFF} Displays...