sysdate_insert_select.txt

来自「orale培训教材包括了所有的sql说明和实例」· 文本 代码 · 共 5 行

SELECT * FROM plsql101_purchase 
WHERE  purchase_date BETWEEN (SYSDATE-30) AND SYSDATE;

DELETE FROM plsql101_purchase
WHERE  SALESPERSON = 'SH';