-- 當(dāng)前日期為標(biāo)準(zhǔn)格式
SELECT * FROM plsql101_product
WHERE  TRUNC(last_stock_date) = '當(dāng)前日期';

DELETE FROM plsql101_product 
WHERE  product_name = 'Square Zinculator';

INSERT INTO plsql101_product VALUES 
     ('Square Zinculator', 45, 1, trunc(sysdate));

 
-- 當(dāng)前日期為標(biāo)準(zhǔn)格式
SELECT * FROM plsql101_product
WHERE  last_stock_date = '當(dāng)前日期';