field_date.txt

orale培训教材包括了所有的sql说明和实例

SELECT * FROM plsql101_product
WHERE  last_stock_date = '15-1月-03';

SELECT * FROM plsql101_product
WHERE  last_stock_date = '15-1月-2003';

SELECT * FROM plsql101_product
WHERE  last_stock_date > '31-12月-02';

SELECT * FROM plsql101_product
WHERE  last_stock_date BETWEEN '01-1月-03' and '31-12月-03';

SELECT * FROM plsql101_product
WHERE  last_stock_date NOT BETWEEN '01-1月-03' and '31-12月-03';