matthewmorris68's Profile
Date Registered:	Thu, May 24, 2012
Message Count:	258 Messages (0.13 average messages per day)
Show all messages by matthewmorris68
Status:	Senior Member
Avatar:	
Last Message:	Mon, 24 October 2016 11:15
Re: Test Strategy Still Valid? -- Matt Morris Article
Last Visited:	Mon, 31 October 2016 06:12

SQL> select * from emp
  2  where deptno = 10 and empno = 7782 or empno = 7902
  3  /
     EMPNO ENAME      JOB              MGR HIREDATE                   SAL       COMM     DEPTNO
---------- ---------- --------- ---------- ------------------- ---------- ---------- ----------
      7782 CLARK      MANAGER         7839 09/06/1981 00:00:00       2450                    10
      7902 FORD       ANALYST         7566 03/12/1981 00:00:00       3000                    20

2 rows selected.

SQL> select * from emp
  2  where deptno = 10 and (empno = 7782 or empno = 7902)
  3  /
     EMPNO ENAME      JOB              MGR HIREDATE                   SAL       COMM     DEPTNO
---------- ---------- --------- ---------- ------------------- ---------- ---------- ----------
      7782 CLARK      MANAGER         7839 09/06/1981 00:00:00       2450                    10

1 row selected.

SQL> select * from emp
  2  where (deptno = 10 and empno = 7782) or empno = 7902
  3  /
     EMPNO ENAME      JOB              MGR HIREDATE                   SAL       COMM     DEPTNO
---------- ---------- --------- ---------- ------------------- ---------- ---------- ----------
      7782 CLARK      MANAGER         7839 09/06/1981 00:00:00       2450                    10
      7902 FORD       ANALYST         7566 03/12/1981 00:00:00       3000                    20

2 rows selected.