INSERT INTO
customers(cust_id,state,post_code) VALUE('Ariel',NULL,'94501');
或
INSERT INTO
customers(cust_id,state,post_code) VALUE('Ariel',,'94501'); 更新数据
UPDATE命令用于修改表中的数据。
UPDATE order_rollup SET(qty,price)=(SELECT SUM(qty),SUM(price) FROM
order_lines WHERE
customer_id='KOHL' WHERE cust_id='KOHL' AND
order_period=TO_DATE('01-Oct-2000') 删除数据
DELETE语句用来从表中删除一行或多行数据,该命令包含两个语句:
1、关键字DELETE
FROM后跟准备从中删除数据的表名。
2、WHERE后跟删除条件
DELETE FROM po_lines WHERE ship_to_state IN ('TX','NY','IL') AND order_date
清空表