随笔分类 -  database / oracle

Oracle data dictionaries
摘要：System Table Name Brief Description Related Views SYS.OBJ$ Contains information about all database objects USER_OBJECTS, ALL_OBJECTS, DBA_OBJECTS SYS. 阅读全文

posted @ 2024-08-14 14:21 winter-loo 阅读(27) 评论(0) 推荐(0)

ora_rowscn 行为观察
摘要：开启行级别改变记录 create table foo3(a int) rowdependencies; 插入数据 insert into foo3 values (1); insert into foo3 values (2); -- 结果为 null select ora_rowscn from 阅读全文

posted @ 2024-03-06 15:42 winter-loo 阅读(43) 评论(0) 推荐(0)

导航