Where clause converts text with date value format to date value : Where « Select Query « Oracle PL / SQL






Where clause converts text with date value format to date value

   
SQL>
SQL> CREATE TABLE product (
  2       product_name     VARCHAR2(25),
  3       product_price    NUMBER(4,2),
  4       quantity_on_hand NUMBER(5,0),
  5       last_stock_date  DATE);

Table created.

SQL>
SQL> INSERT INTO product VALUES ('S', 99, 1, '15-JAN-03');

1 row created.

SQL> INSERT INTO product VALUES ('M', 75, 1000, '15-JAN-02');

1 row created.

SQL> INSERT INTO product VALUES ('C', 50, 100, '15-JAN-03');

1 row created.

SQL> INSERT INTO product VALUES ('R', 25, 10000, null);

1 row created.

SQL>
SQL> SELECT * FROM product;

PRODUCT_NAME              PRODUCT_PRICE QUANTITY_ON_HAND LAST_STOC
------------------------- ------------- ---------------- ---------
S                                    99                1 15-JAN-03
M                                    75             1000 15-JAN-02
C                                    50              100 15-JAN-03
R                                    25            10000

SQL>
SQL> SELECT * FROM product WHERE  last_stock_date = '09-JUL-00';

no rows selected

SQL>
SQL> DROP TABLE product;

Table dropped.

SQL>
SQL>

   
    
  








Related examples in the same category

1.Query a varchar2 type column in where statement
2.The TO_DATE function in where clause
3.WHERE clause with a GROUP BY clause
4.A list of all Employees whose salary is more than $5000
5.Use an analytical function in a WHERE clause
6.Using the WHERE, GROUP BY, and HAVING Clauses Together
7.Use ROWNUM in where clause
8.Use Trunc in where clause
9.Combining WHERE Conditions
10.List all employees who are younger than Jane
11.List all employees with salary between 1300 and 1600