使用 字符串中使用’
Insert into products
Values(12,1,’o’’Malley’,null,null);
Insertintocustomers(customer_id,first_name,last_name)
Select 10,first)name,last_name
From custormers
Where customer_id=1
Merge into products p
Using product_changs pc on(
p.product_id=pc.product_id
)
When matched then
Update
Set p.product_type_id=pc.product_type_id,
p.price=pc.price
when not matched then
insert(
p.product_id,
p.price
)
Values(pc.product_id,pc.price)
保存点
Dml ssssss
Savepoint save1;
Dml ssssssssssss
Rollback to savepoint save1
Rollback ---回滚整个。
容易出现的问题是:
幻想读,不可重复读,读脏数据
隔离级别对应是:
Read uncommitted 允许所有,
Read committed 允许幻想读,不可重复读,但是不允许脏读,
Repeatable read 允许幻想读,但是不允许不可重复读和脏读
Serializable 都不允许。
闪回:
Dba 操作:
Grant execute on sys.dbms_flashback to store;
时间闪回
Execute dbms_flashback.enable_at_time(sysdate-10/1440)
系统便更号 闪回。
Variable current_scn number
Execute : current_scn number=DBMS_FLASHBACK.GET_SYSTEM_CHANGE_NUMBER();
EXECUTE DBMS_FLASHBACK.ENABLE_AT_SYSTEM_CHANGE_NUMBER(:CURRENT_SCN)