简单SQL语句

2024-11-18 12:46:28
推荐回答(2个)
回答(1):

insert into orders(ordernum,orderdate,distrinum,paidate) values('119','1905-06-8','1022','1905-06-9')
update orders set orderdate='2003-07-11' where ordernum='118'
望采纳。

回答(2):

insert into orders (OrderNum, OrderDate, DistriNum, PaidDate) Values (119, to_date('yyyy-mm-dd', '1905-06-08'), 1022, to_date('yyyy-mm-dd', '1905-06-09'));

Update orders set OrderDate = to_date('yyyy-mm-dd', '2003-07-11') where OrderNum = 118;