cici_new_1987

摘要： 1 创建数据类型CREATE OR REPLACE TYPE str_split IS TABLE OF VARCHAR2 (4000);2 创建返回值为table的函数CREATE OR REPLACE FUNCTION P_TEST_TABLE(p_string IN VARCHAR2, p_delimiter IN VARCHAR2)/*拆分字符串函数*/ RETURN str_split PIPELINEDAS v_length NUMBER := LENGTH(p_string); v_start NUMBER := 1; v_index NUMBER;BEGIN WHILE(v_. 阅读全文

摘要： oracle 11 g标准版正确闪回执行方式：SQL> shutdown; SQL> startup mount; 数据库启动到mount下 SQL> alter table SY_GLOBAL_NAME enable row movement;--意思是允许Oracle修改rowid。Oracle插入数据时会为该条数据分配唯一rowid并且不变，要启用闪回功能必须开启可修改rowid功能 SQL> SQL> flashback table SY_GLOBAL_NAME TO TIMESTAMP TO_TIMESTAMP('2013-05-04 03:16 阅读全文

摘要： 1 查看指定用户SQL> show user;USER is "CICI"2 查看表空间使用情况select distinct (default_tablespace) ,temporary_tablespace from dba_users;3 字典表系列select * from v$option;select * from v$version; 阅读全文

摘要： sql格式或者语法错误例如将‘ 改为' 阅读全文

摘要： 当遇到如上错误时候执行如下语句SQL> exitDisconnected from Oracle Database 10g Express Edition Release 10.2.0.1.0 - Production[root@localhost Desktop]# sqlplus "sys/cici123love as sysdba"SQL*Plus: Release 10.2.0.1.0 - Production on Sat Feb 16 11:38:47 2013Copyright (c) 1982, 2005, Oracle. All rights res 阅读全文

摘要： 执行如下语句直到问题解决bash-4.1$ sqlplus / as sysdbaSQL*Plus: Release 10.2.0.1.0 - Production on Sat Feb 16 04:45:20 2013Copyright (c) 1982, 2005, Oracle. All rights reserved.Connected to:Oracle Database 10g Express Edition Release 10.2.0.1.0 - ProductionSQL> alter database open;Database altered. 阅读全文

摘要： 执行如下语句就可以解决SQL> connect sys/123 as sysdba;已连接。SQL> shutdown normalORA-01109: 数据库未打开已经卸载数据库。ORACLE 例程已经关闭。SQL> startup mount;ORACLE 例程已经启动。Total System Global Area 171966464 bytesFixed Size 787988 bytesVariable Size 145750508 bytesDatabase Buffers 25165824 byte... 阅读全文

摘要： 以下两段代码等价：段落1<insert id="addPaBonusInputItemInfo" parameterClass="linkMap"> <![CDATA[ INSERT INTO BN_PARAM_ITEM ( PARAM_ITEM_NO, PARAM_ITEM_ID, DATA_TYPE, CREATE_DATE, CREAT... 阅读全文

摘要： Linux版本CentOS 6.3OS环境VMware® Workstation9.0.0 build-812388oracle安装文件位置： G:\Program Files\Red Hat Enterprise Linux 4\Exchange Data\ORACLE\oracle-xe-10.2.0.1-1.0.i386.rpmPreparing查询删除原有oracle服务[root@localhost Desktop]# rpm -qa|grep oracleoracle-xe-10.2.0.1-1.0.i386[root@localhost Desktop]# rpm -e 阅读全文

摘要： TOMCAT J2EE项目连接池配置/opt/apache-inComBOMP/confServer.xml 相关配置信息<GlobalNamingResources> <!-- Editable user database that can also be used by UserDatabaseRealm to authenticate users --> <Resource name="UserDatabase" auth="Container" type="org.apache.catalina.UserD 阅读全文