28、SQL*Plus基础与脚本编写

SQL*Plus基础与脚本编写

1. SQL*Plus命令快捷方式与目录路径指定

在SQL*Plus中， @ 符号是 START 命令的快捷方式。例如：

SQL> L
  1* select * from departments
SQL> @result1
CODE DESCRIPTION                    CAT DURATION
---- ------------------------------ --- --------
SQL  Introduction to SQL            GEN        4
OAU  Oracle for application users   GEN        1
JAV  Java for Oracle developers     BLD        4
PLS  Introduction to PL/SQL         BLD        1
XML  XML for Oracle developers      BLD        2
ERM  Data modeling with ERM         DSG        3
PMT  Process modeling techniques    DSG        1
RSD  Relational system design       DSG        2
PRO  Prototyping                    DSG        5
GEN  System generation