Oracle Sqlplus Common Commands

1. Connect or Conn
2. Show user
3. Clear Screen
4, Spool
Enter: Spool d:\sql.txt after landing in Sqlplus
Result: The file will be created in the D drive Sql.txt
Then execute: SELECT * from EMP;
Then execute: SELECT * FROM dept;
Re-enter: spool off;
Result: The contents of the screen just now will be written to the Sql.txt file.
5. Edit
Edits the last SQL statement that was executed.
Perform select * from EMP first;
Execute edit again;
6. Set time on
Set Time off
7. Show Error
8. Host
command to invoke the operating system
Host mkdir D:\test
Result: A folder is created
9, @
Execute SQL Script
Create a sql.sql file with show User content; SELECT * from EMP;
@d:\sql.sql

Oracle Sqlplus Common Commands