Sqlplus Command Format and set usage and interpretation in sqlplus

Sqlplus Command Format and set Usage and interpretation in sqlplus [oracle @ oracle02 username] $ sqlplus -- helpSQL * Plus: Release 9.2.0.4.0-Production Usage: SQLPLUS [[<option>] [<logon>] [<start>] where <option> :: =-H |-V | [[-L] [-M <o>] [-R <n>] [-S] <logon> :: = <username> [/<password>] [@ <connect_string>] |/NOLOG <start >::=@ <URI >|< filename> [. <ext>] [<parameter>...] "-H" displays the SQL * Plus version banner and usage s Yntax "-V" displays the SQL * Plus version banner "-L" attempts log on just once "-M <o>" uses HTML markup options <o> "-R <n> "uses restricted mode <n>"-S "uses silent mode www.2cto.com/nolog means not logging on to the database server. If no/nolog parameter exists, sqlplus requires the user name and password. If you use the shutdown command in the SQL * plus environment to shut down the database, you must first enter the sqlplus environment without logging on to the database server, run the startup command to start the database. If the database is not started, you cannot log on to the database or verify the user name and password. Www.2cto.com sqlplus/nolog -- run the sqlplus command to enter the sqlplus environment. The nolog parameter indicates no logon; SQL> connect/as sysdba -- connect to the database as a system administrator (sysdba; if you need to manage the database, You need to log on to the database in this way, or connect sys @ service_name as sysdba, where service_name is the customer's tnsname service name you configured. SQL> startup -- if the database is not started, data 1, sqlplus '/as sysdba' and 2 will be started normally after the above steps are connected, sqlplus/nologSQL> connect/as sysdba set heading off ----- do not display the column name set echo off for each line ----- do not repeatedly display the SQL statement set line 200 ----- set pages to display 200 characters for each line 0 ----- set feed off without paging ------ set feedback off without displaying the SQL statement running result ----- set trimspool on without displaying the number of rows queried or modified by the current SQL statement ----- remove redirection (spool) output the trailing space of each line set verify off ----- do not show the statement set termout on before and after the substitution variable is replaced ----- show the command execution result set serveroutput on ------ whether it is displayed on the screen