Common Oracle commands (1)

1. User Logon

Conn system/Manager

Conn Scott/Tiger

Ii. Change the password

Enter passw and press enter to modify the settings as prompted.

3. Switch the Login User

Conn username/password

4. display the currently logged-on user

Show user

V. Start and @ commands

For example, if the root directory of disk D contains a Lida. SQL file, the file content is select * from EMP;

Run start D: \ Lida. SQL or @ D: \ Lida. SQL to obtain the same result as if you directly input select * from EMP.

Vi. Edit command

Run edit D: \ Lida. SQL to open the Lida. SQL file. You can edit and modify the SQL text by yourself.

VII. Spool commands

Usage:

Spool D: \ AA. SQL: A file named AA. SQL is generated under drive D.

Select * from EMP; obtain the query result.

Spool off; intercept the statements on the screen and save them to the AA. SQL file;

8. Exit

Exit window

9. Set linesize

Set linesize 90; // set the display line width to 90. The default value is 80 characters.

10. pagesize

Set pagesize 5; // set the number of rows displayed on each page to 5. The default value is 14.

11. Disc [connect]

This command is used to disconnect from the current database.