06 2009 档案
摘要:启用归档模式SQL> shutdown immediate;SQL> startup mount; SQL>alter system set log_archive_dest_1="LOCATION=d:\oracle\oradata\archivelog" scope=spfile;SQL> alter system set log_archive_start=true ...
阅读全文
摘要:当insert all 遇到 sequence 这几天在修改商函2.0中相关的PL/SQL包代码时,在实现这样一个SQL时:insert all into bo(object_name,sn) values(object_name,seqkey) into co(object_name,sn) values(object_name,seqkey)select object_name ,sq1.ne...
阅读全文