Use Trunc in where clause : Where « Select Query « Oracle PL / SQL






  1. Oracle PL / SQL
  2. Select Query
  3. Where

Use Trunc in where clause

   
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 ('Small Widget', 99, 1, '15-JAN-03');

1 row created.

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

1 row created.

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

1 row created.

SQL> INSERT INTO product VALUES ('Round Church Station', 25, 10000, null);

1 row created.

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

no rows selected

SQL>
SQL>
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.Where clause converts text with date value format to date value
9.Combining WHERE Conditions
10.List all employees who are younger than Jane
11.List all employees with salary between 1300 and 1600