sysdate_insert.txt

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

INSERT INTO plsql101_purchase VALUES 
     ('Small Widget', 'SH', sysdate,10 );

INSERT INTO plsql101_purchase VALUES 
     ('Medium Wodget', 'SH', sysdate-14, 15);
INSERT INTO plsql101_purchase VALUES 
     ('Round Snaphoo', 'SH', sysdate-7, 25);
INSERT INTO plsql101_purchase VALUES 
     ('Chrome Phoobar', 'SH', sysdate+7, 10);