Oracle Sqlplusコマンドログイン複数方法ケーススタディ

sqlplus [ <option>] [{logon | /nolog}] [<start>] ]
<option> for: [-C <version>] [-L] [-M "<options>"] [-R <level>] [-S]

-C <version> Sets the compatibility of the affected command to the <version> specified version. This version has the "x.y[.z]" format. For example, -C 10.2.0
-L Tries to log in only once, instead of prompting again in case of errors.
-M "<options>" Sets the automatic HTML tags for the output. The format of the options is :
               HTML [ON|OFF] [HEAD text] [BODY text] [TABLE text] [ENTMAP {ON|OFF}] [SPOOL {ON|OFF}] [PRE[FORMAT] {ON|OFF}]
-R <level> Sets the restricted mode to disable SQL*Plus commands that interact with the file system. The maximum restriction level is -R 3, which disables all user commands that interact with the file system.
-S sets the promptless (slient) mode, which hides the prompting of commands and the display of callbacks.

 <logon> for: {<username>[/<password>][@<connect_identifier>] | / }[AS {SYSDBA | SYSOPER | SYSASM}] [EDITION=value]

 Specify the database account username, password and connection identifier for the database connection. If there is no connection identifier, SQL*Plus will connect to the default database.
 The AS SYSDBA, AS SYSOPER and AS SYSASM options are database administrative privileges.

 The <connect_identifier> can be of the form Net Service Name or Easy Connect.
   @[<net_service_name> | [//]Host[:Port]/<service_name>]
   <net_service_name> is the simple name of the service, which resolves to a connection descriptor.
   Example: Connecting to a database using a Net service name, and the database Net service name is ORCL.
      sqlplus myusername/mypassword@ORCL
   Host Specifies the host name or IP address of the database server computer.
   Port Specifies the listening port on the database server.
   <service_name> Specifies the service name of the database to be accessed.
   Example: Connect to the database using an easy connection, and the service name is ORCL.
      sqlplus myusername/mypassword@Host
 The /NOLOG option starts SQL*Plus without connecting to the database.
 EDITION Specifies the value of the session version.

<start> for: @<URL>|<filename>[. <ext>] [<parameter> ...]
Run the specified SQL*Plus script from the web server (URL) or local file system (filename.ext) using the specified parameters that will be assigned to the alternative variables in the script.

After starting SQL*Plus and executing the CONNECT command, the site summary file (for example, $ORACLE_HOME/sqlplus/admin/glogin.sql) and the user summary file (for example, login.sql in the working directory) are run. These files contain SQL*Plus commands.

sqlplus / as sysdba

sqlplus "/as sysdba"    

sqlplus tiger/scott@localhostsqlplus tiger/[email protected]:1521

sqlplus 

conn tigerconn tiger/[email protected]