doing13826400396的专栏

[code="sql"] declare time_before binary_integer; time_after binary_integer; begin time_before :=DBMS_UTILITY.get_time(); FOR i IN 1..2 LOOP dbms_lock.sleep(1);--休眠函数，要有管理员权限才能执行 EN...

[size=large][b]1.索引表[/b][/size] 索引表是将数据保存在内存中，元素个数没有限制,并且下标可以是负值。 [b]1.1.定义索引表[/b] [code="sql"] --定义索引表类型 type type_name is table of element_type [not null] index by key_type;...

[size=large][b]1.触发器的创建[/b][/size] [quote] CREATE TRIGGER [schema.]trigger_name {BEFORE|AFTER} {UPDATE|INSERT|DELETE} ON [schema.]table_name [ [REFERENCING correlation_names] FOR EACH ROW [WHEN (c...