Oracle常用的SQL*Plus命令

1. desc[ribs]     table_name                                              显示表的结构

2. set line[size] {80|n}                                                     每一行显示的宽度，默认是80

3. n text                                                                            返回缓冲区的第n行并修改第N行的数据为text{修改后的sql语句}

4. L                                                                                    输出缓冲区的sql语句

5. /                                                                                    执行缓冲区的sql语句

6. n                                                                                   显示的指定当前的行为第n行

7. a[ppend]                                                                       修改当前的行把添加的数据放在当前行的尾部 例如:a ,job,sal

8. del  [n]                                                                          当没有指定参数 [n] 删除当前的行 

9. C[change]                                                                     修改指定的值  c /dept/emp

10. save D:/sql/emp                                                          保存缓冲区的SQL语句进入D盘的sql文件夹的emp文件里面

11.

         SQL> spool d:/sql/output
         SQL> select * from emp;                                          这时候将会把缓冲区的sql语句和搜索得到的结果集保存进output文

         SQL> spool off;                                                        件里面

12. select instance_name,version from v$instance;        获取当前数据库的版本信息