English | 简体中文 | 繁體中文 | Русский язык | Français | Español | Português | Deutsch | 日本語 | 한국어 | Italiano | بالعربية
1Introduction:
Oracle's sql*Plus is a client tool for interacting with Oracle. In sqlplus, you can run sqlplus commands and sqlplus statements. The DML, DDL, and DCL statements we usually refer to as sqlplus statements can all be stored in a memory area called sql buffer after execution. Only the most recently executed sql statement can be saved in the sql buffer. We can modify the sql statements stored in the sql buffer and execute them again. Sqlplus usually deals with databases.
2Common commands
sqlplus username/password, for example: normal user login sqlplus scott/tiger sqlplus username/password@net_service_name such as: sqlplus scott/tiger@orcl
sqlplus username/password as sysdba such as: sqlplus sys/admin as sysdba sqlplus username/password@//host:port/sid Note: sys and system need to log in as sysdba to enter sql*plus, you can use conn to connect to other users, such as: conn sys/admin as sysdba in DOS environment (Windows system) or terminal (Linux system), enter 'sqlplus' /?
suguniang@SuGuNiang:/home/oracle$ sqlplus /?
The results shown below are some detailed information about Oracle usage:
SQL*Plus: Release 11.2.0.1.0 Production on Thu Sep 15 12:55:27 2016
Copyright (c) 1982, 2010, Oracle. All rights reserved.
SQL*Plus: Release 11.2.0.1.0 Production
Copyright (c) 1982, 2010, Oracle. All rights reserved.
Using SQL*Plus executes SQL, PL/SQL and SQL*Plus statements.
Usage 1: sqlplus -H | -V
-H Display SQL*Plus version and usage help.
-V Display SQL*Plus version.
Usage 2: sqlplus [ [
As mentioned above, this is the complete list of SQL commands in Oracle SQLplus introduced by the editor, hoping it will be helpful to everyone. If you have any questions, please leave a message, and the editor will reply to everyone in time. Here, I also want to express my sincere gratitude to everyone for their support of the YANHUA tutorial website!