- 博客(4)
- 收藏
- 关注
RSS订阅转载 游标例子
Example 6-18 Implicit Cursor FOR LOOP StatementBEGIN FOR item IN ( SELECT last_name, job_id FROM employees WHERE job_id LIKE '%CLERK%' AND manager_id > 120 ORDER BY last_name
2016-09-05 21:34:46
332
原创 duplicate报错：ORA-12154
$ rman target sys/oracle@anyang auxiliary sys/oracle@dupRecovery Manager: Release 12.1.0.2.0 - Production on Mon Aug 29 12:03:42 2016Copyright (c) 1982, 2014, Oracle and/or its affiliates.
2016-09-05 13:42:56
830
原创 启动数据库报错：
SD2-100-RAC1:/home/oracle>srvctl start database -d anyangPRCR-1079 : Failed to start resource ora.anyang.dbCRS-5017: The resource action "ora.anyang.db start" encountered the following error: OR
2016-09-05 13:34:19
580
原创 DG同步测试脚本
sqlplus / as sysdba drop table t1;create table t1(id number,check_for_dg varchar2(30));declarei number;begindelete t1 where 1=1;insert into t1 values(1,to_char(sysdate,'YYYY-MM-DD HH24:M
2016-09-05 13:29:59
911
空空如也
空空如也
TA创建的收藏夹 TA关注的收藏夹
TA关注的人