SQL> 2

2* where job = 'CLERK

SQL> a ' and sal > 1000

2* where job = 'CLERK' and sal > 1000

SQL> /

EMPNO ENAME JOB SAL

---------- ---------- --------- ----------

7876 ADAMS CLERK 1100

7934 MILLER CLERK 1300

SQL> 2

2* where job = 'CLERK' and sal > 1000

SQL> c /and/or

2* where job = 'CLERK' or sal > 1000

SQL> /

EMPNO ENAME JOB SAL

---------- ---------- --------- ----------

7369 SMITH CLERK 800

7499 ALLEN SALESMAN 1600

7521 WARD SALESMAN 1250

7566 JONES MANAGER 2975

7654 MARTIN SALESMAN 1250

7698 BLAKE MANAGER 2850

7782 CLARK MANAGER 2450

7788 SCOTT ANALYST 3000

7839 KING PRESIDENT 5000

7844 TURNER SALESMAN 1500

7876 ADAMS CLERK 1100

EMPNO ENAME JOB SAL

---------- ---------- --------- ----------

7900 JAMES CLERK 950

7902 FORD ANALYST 3000

7934 MILLER CLERK 1300

SQL> 2

2* where job = 'CLERK' or sal > 1000

SQL> c /or sal > 1000

2* where job = 'CLERK'

SQL> /

EMPNO ENAME JOB SAL

---------- ---------- --------- ----------

7369 SMITH CLERK 800

7876 ADAMS CLERK 1100

7900 JAMES CLERK 950

7934 MILLER CLERK 1300

SQL> l

1 select empno, ename, job, sal from emp

2 where job = 'CLERK'

3*

SQL>

SQL> l 2

2* where job = 'CLERK'

SQL> select empno, ename, job

2 from emp;

EMPNO ENAME JOB

---------- ---------- ---------

7369 SMITH CLERK

7499 ALLEN SALESMAN

7521 WARD SALESMAN

7566 JONES MANAGER

7654 MARTIN SALESMAN

7698 BLAKE MANAGER

7782 CLARK MANAGER

7788 SCOTT ANALYST

7839 KING PRESIDENT

7844 TURNER SALESMAN

7876 ADAMS CLERK

EMPNO ENAME JOB

---------- ---------- ---------

7900 JAMES CLERK

7902 FORD ANALYST

7934 MILLER CLERK

14 rows selected.

SQL> 2

2* from emp

SQL> i where job = 'CLERK';

SQL> 2

2* from emp

SQL> 3

3* where job = 'CLERK'

SQL> /

EMPNO ENAME JOB

---------- ---------- ---------

7369 SMITH CLERK

7876 ADAMS CLERK

7900 JAMES CLERK

7934 MILLER CLERK

SQL> r

1 select empno, ename, job

2 from emp

3* where job = 'CLERK'

EMPNO ENAME JOB

---------- ---------- --------

7369 SMITH CLERK

7876 ADAMS CLERK

7900 JAMES CLERK

7934 MILLER CLERK

SQL> sav a:/clerk

Created file a:/clerk.sql

SQL> get a:/clerk.sql

1 select empno, ename, job

2 from emp

3* where job = 'CLERK'

SQL> /

EMPNO ENAME JOB

---------- ---------- ---------

7369 SMITH CLERK

7876 ADAMS CLERK

7900 JAMES CLERK

7934 MILLER CLERK