SQL * Plus File commands - Oracle

SQL * Plus File commands - Oracle


1. SAVE filename
2. GET filename
3. START filename
4. @ filename
5. EDIT filename
6. SPOOL filename
7. EXIT


SQL> L
1. Select lastname, manager_id, dept_no
2* from emp;


SQL > SAVE my_query
File created my_query


SQL > START my_query
lastname          manager_id      dept_id
-----------------------------------------
King                                                   1
Kochaar                         80                1
..........
10 rows updated