- 博客(4)
- 收藏
- 关注
原创 ref cursor sys_refcursor传递结果集
SQL>set linesize 200 pages 100SQL> variable v refcursor;SQL>exec open :v for'select * from emp';PL/SQL procedure successfully completed.SQL>print:v; EMPNO ENAME ...
2016-11-11 09:19:54 255
原创 Duplicate a Database Using RMAN in Oracle Database 11g Release 2
Duplicate a Database Using RMAN in Oracle Database 11g Release 2This article is an update of a previous Oracle 9i article.IntroductionBackup-Based DuplicationActive Database DuplicationRMA...
2016-11-03 15:38:25 239
原创 Automatic Storage Management
SYSASM Role When Automatic Storage Management (ASM) was introduced with Oracle Database 10g, it somewhat blurred the line between DBAs and sysadmins in terms of their storage allocation functions...
2016-11-03 15:33:48 910
原创 ASM FAQ
ASM FAQ Oracle Automatic Storage Management (ASM) FAQContents1 Why should we use separate ASM home?2 How many ASM instances should one have?3 How many diskgroups should one...
2016-11-03 15:29:32 192
空空如也
空空如也
TA创建的收藏夹 TA关注的收藏夹
TA关注的人