webseven-CSDN博客

原创如何在oracle中输出带单引号的字符串

在SQL或者PLSQL中如果要表达一个带有特殊字符的字符串时，通常要用‘’包装起来。但如果字符串本身包含'A'B'这样的字符，那么实现起来有点繁琐。比如：This is a 'test'!第一种实现方式：SQL> select 'This is a ''test''!' from dual; --其中的''表是的是两个单引号,不是一个双引号'THISISA''TEST''!

2013-11-03 17:08:34 1607

原创如何处理11gR2 RAC下oc4j和gsd服务为OFFLINE状态？

1.11gR2安装好后,oc4j和gsd服务器状态为offline. [root@myrac2 ~]# uname -aLinux myrac2 2.6.18-308.el5 #1 SMP Fri Jan 27 17:17:51 EST 2012 x86_64 x86_64 x86_64 GNU/Linux[root@myrac2 ~]# crs_stat -t -vName

2013-09-01 16:55:26 1031

转载 DataPump Export (EXPDP) Error ORA-39095 Dump File Space Has Been Exhausted [ID 559692.1]

In this Document Symptoms Cause SolutionApplies to: Oracle Server - Enterprise Edition - Version: 10.2.0.1 to 11.2.0.2 - Release: 10.2 to 11.2Information in this document applie

2013-06-21 13:23:13 1141