摘要: 启用归档模式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 ... 阅读全文
posted @ 2009-06-01 16:33 jimeper 阅读(616) 评论(0) 推荐(0) 编辑
摘要: 当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... 阅读全文
posted @ 2009-06-01 16:15 jimeper 阅读(1644) 评论(0) 推荐(1) 编辑