修改表的内容-RETURNING/DEFAULT/MERGE/时间查询闪回/系统变更号查询闪回

returning子句：返回使用聚合函数计算的结果

VARIABLE average_product_price NUMBER

UPDATE products

SET price = price * 0.75

RETURNING AVG(price) INTO :average_product_price;

为列定义默认值：

CREATE TABLE  order_status (

order_status_id INTEGER

CONSTRAINT default_example_pk PRIMARY KEY,

status VARCHAR2(20) DEFAULT ' Order placed' NOT NULL,

last_modified DATE DEFAULT SYSDATE);

使用MERGE合并行：

MERGE INTO products p

USING product_changes pc ON (

p.product_id = pc.product_id

)

WHEN MATCHED THEN

UPDATE

SET

p.product_type_id = pc.product_type_id,

p.name &