BETWEEN (SYSDATE-30) AND SYSDATE : BETWEEN AND « Select Query « Oracle PL / SQL






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

BETWEEN (SYSDATE-30) AND SYSDATE

   
SQL> set serveroutput on
SQL>
SQL>
SQL> CREATE TABLE purchase (
  2       product_name  VARCHAR2(25),
  3       salesperson   VARCHAR2(3),
  4       purchase_date DATE,
  5       quantity      NUMBER(4,2));

Table created.

SQL>
SQL> INSERT INTO purchase VALUES ('Small Widget', 10, sysdate, '1);
ERROR:
ORA-01756: quoted string not properly terminated


SQL> INSERT INTO purchase VALUES ('Medium Widget', 15, sysdate-14, 2);

1 row created.

SQL> INSERT INTO purchase VALUES ('Round Station', 25, sysdate-7, 3);

1 row created.

SQL> INSERT INTO purchase VALUES ('Product Number', 10, sysdate+7, 4);

1 row created.

SQL>
SQL> SELECT * FROM purchase
  2  WHERE  purchase_date BETWEEN (SYSDATE-30) AND SYSDATE;

PRODUCT_NAME              SAL PURCHASE_   QUANTITY
------------------------- --- --------- ----------
Medium Widget             15  05-JUN-08          2
Round Station             25  12-JUN-08          3

SQL>
SQL>
SQL> DROP TABLE purchase;

Table dropped.

SQL>








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...And' converts text value to date type value
6.BETWEEN operator checks whether a variable value is between two values of the same datatype.
7.Performing Range Tests with between ... and
8.Performing Range Tests, not between ... and
9.All flower product with price range between 10 and 25