使用 Oracle 命令列介面的例子

基本的 Oracle 查询语句

SQL> select DEPARTMENT_ID, DEPARTMENT_NAME from DEPARTMENTS where LOCATION_ID = 1700;

DEPARTMENT_ID DEPARTMENT_NAME
----------------------------------------------------------------
           10 Administration
           90 Executive
          100 Finance
          110 Accounting
          120 Treasury
          270 Payroll

6 rows selected.

SQL>