Syntax for ORALCE client tool Sql*plus

The ㈠ command line uses sqlplus syntax to explore.

Serial number	Command line	Examples of usage
①	Sqlplus	> Sqlplus
Ii	sqlplus [option]	> sqlplus-l
③	Sqlplus [Logon]	> sqlplus [email protected]
④	Sqlplus [/nolog]	> Sqlplus/nolog
⑤	Sqlplus [start]

① screen prompts for user name, password to connect to the default database

② command Options

Options	Note
-C <version>	Sets the compatibility of the affected command to the version specified by <version>.
-L	Try to log in only once
-M "<options>"	Sets the automatic HTML markup for the output. The format is: HTML [on| OFF] [HEAD text] [BODY text] [TABLE text] [Entmap {on| OFF}] [SPOOL {on| OFF}] [Pre[format] {on| OFF}]
-R <level>	Set the restricted mode to disable the Sql*plus command that interacts with the file system. The level can be 1, 2, or 3. The maximum limit level is-R 3, which disables all user commands that interact with the file system.
-S	Sets the silent mode, which hides the display of the command's Sql*plus flag, hints, and echoes.

③ Specifies the user name, password, and database connection identifier of the connection database

Usage	Note
Sqlplus {username}	Prompt to enter password, connect to default database
Sqlplus {username}/	Effect ditto
Sqlplus {Username}[/password]
Sqlplus {username}[@<connect_identifier>]	For example: > sqlplus [email protected]
Sqlplus {username} [As {SYSDBA | Sysoper | SYSASM}]	Set Database administration Permissions

can be a "network service name" or "host Address: Port number/Global database name" in the <connect_identifier>

The global database name is "My01.com", and the correct example usage is:

aa> sqlplus [email protected]

bb> Sqlplus System/[email protected]:1521/my01.com

*aa "My01" is the network service name, is the listener:

650) this.width=650; "src=" Http://s3.51cto.com/wyfs02/M00/74/61/wKioL1Ybz83jP4N-AAB_qoJSrCE740.jpg "title=" Qq20151012231934.png "alt=" Wkiol1ybz83jp4n-aab_qojsrce740.jpg "/>

④ start sql*plus without connecting to the database

⑤ to Be Continued ...

650) this.width=650; "src=" Http://s3.51cto.com/wyfs02/M02/74/63/wKiom1YbpuWiRQ3yAABm5lAGjro733.jpg "title=" Logo.jpg "alt=" Wkiom1ybpuwirq3yaabm5lagjro733.jpg "/>

This article from "Little Cui's experimental notes" blog, declined to reprint!

Syntax for ORALCE client tool Sql*plus