Performing Range Tests, not between ... and : BETWEEN AND « Select Query « Oracle PL / SQL






  1. Oracle PL / SQL
  2. Select Query
  3. BETWEEN AND

Performing Range Tests, not between ... and

   
SQL>
SQL> CREATE TABLE emp (
  2     empID      INT NOT NULL PRIMARY KEY,
  3     CourseID    INT NOT NULL,
  4     ProfessorID INT NOT NULL,
  5     SustainedOn DATE,
  6     Comments    VARCHAR(255));

Table created.

SQL> INSERT INTO emp (empID,CourseID,ProfessorID,SustainedOn,Comments) VALUES (1,1,1,DATE '2003-03-12','Hard');

1 row created.

SQL> INSERT INTO emp (empID,CourseID,ProfessorID,SustainedOn,Comments) VALUES (2,2,1,DATE '2003-03-13','Simple');

1 row created.

SQL> INSERT INTO emp (empID,CourseID,ProfessorID,SustainedOn,Comments) VALUES (3,3,2,DATE '2003-03-11','1 hour long');

1 row created.

SQL>
SQL> SELECT empID, SustainedOn, Comments FROM emp
  2  WHERE SustainedOn NOT BETWEEN DATE '2003-03-20' AND DATE '2003-03-24';

     EMPID SUSTAINED
---------- ---------
COMMENTS
--------------------------------------------------------------------------------
         1 12-MAR-03
Hard

         2 13-MAR-03
Simple

         3 11-MAR-03
1 hour long


3 rows selected.

SQL>
SQL> drop table emp;

Table dropped.








Related examples in the same category

1.Using the BETWEEN ... AND operator for Number
2.Exclude a range with NOT operator: NOT BETWEEN AND
3.Between for Date data type
4.Using the BETWEEN Operator for integer
5.BETWEEN (SYSDATE-30) AND SYSDATE
6.'Between...And' converts text value to date type value
7.BETWEEN operator checks whether a variable value is between two values of the same datatype.
8.Performing Range Tests with between ... and
9.All flower product with price range between 10 and 25