- 博客(16)
- 资源 (7)
- 问答 (1)
- 收藏
- 关注
原创 ORACLE 函数返回对象类型结果集
注:适用于表中只有一行数据,如果多行数据建议用表类型结果集创建对象类型CREATE OR REPLACE TYPE "T_B_PARAMETER" AS OBJECT( PARAMETER_ID NUMBER , PARAMETER_WITHDRAWAL_R NUMBER(15,2), PARAMETER_W
2014-09-16 15:03:51 909
原创 ORACLE 树形结构数据 查询某结点下全部子节点无限递归的前2个数据
SELECT * FROM ( SELECT * FROM TABLE_NAME CONNECT BY PRIOR _LEVEL_ID = _UPPER_LEVEL_ID AND _NUM <= 2 START WITH _UPPER_LEVEL_ID IN ( SELEC
2014-01-16 14:14:57 840
转载 ORACLE-查询最近N个月记录
SELECT * FROM TABLE_NAME AWHERE TRUNC(A.COLUMN_NAME) > ADD_MONTHS(TO_DATE(TO_CHAR(SYSDATE , 'YYYY-MM-DD') , 'yyyy-mm-dd') , -3)
2013-12-27 10:45:21 1946
转载 ORACLE查询某字符在字符串中出现次数
select length(regexp_replace(replace('ORACLE查询某字符在字符串中出现次数', '字符', '|'), '[^|]+', '')) as COUNT from dual;
2013-12-04 21:08:01 5297
原创 ORACLE 获取字符串中数字
select REGEXP_SUBSTR('xxx公司创建于1990年','[[:digit:]]+') from dual; 但仅能获取第一个数字串 如 select REGEXP_SUBSTR('xxx公司创建于1990年 , 目前已是世界500强公司','[[:digit:]]+') from dual; 仅能获取到1990
2013-10-31 14:24:36 655
转载 ORACLE ORA-01034: ORACLE not available解决
由于ORA-00844: Parameter not taking MEMORY_TARGET into accountORA-00851: SGA_MAX_SIZE size1 cannot be set to more than MEMORY_TARGET size2产生ORA-01034: ORACLE not available导致oracle无法启动过程如下:1. pf
2013-10-23 16:31:57 762
原创 ORACLE 异常处理
BEGIN DBMS_OUTPUT.PUT_LINE('1'); EXCEPTION when others then DBMS_OUTPUT.PUT_LINE('2'); END;
2013-10-23 15:24:51 432
原创 ORACLE insert into select
INSERT INTO TABLE_NAME(USERNAME , JID) SELECT '1' , '2' FROM DUAL;
2013-08-21 14:17:22 770
转载 ORACLE 两日期相差年数
SELECT EXTRACT(YEAR FROM SYSDATE) - EXTRACT(YEAR FROM TO_DATE('2011-06-05','YYYY-MM-DD')) YEARS FROM DUAL;
2013-08-12 08:51:21 5844
原创 ORACLE REPLACE语法
SELECT REPLACE(JID , '@127.0.0.1' , '') , JID FROM TABLE_NAME WHERE ROOMID = 1;
2013-07-12 09:53:18 738
原创 ORACLE MERGE INTO
merge into ICOM_TEACH_PROCESS_TABLE Tusing (select decode((select TEACH_PROCESS_ID from ICOM_TEACH_PROCESS_TABLE where TEACH_PROCESS_ID = 6) , null , -1) as TEACH_PROCESS_ID from dual) UTon (T.
2013-04-11 11:13:19 507
原创 oracle 查询树形结构最底级节点
表结构 : GOODS_TYPE_ID , GOODS_TYPE_TITLE , _UPPER_GOODS_TYPE_IDselect * from ICOM_GOODS_TYPE_TABLE a , (select I.GOODS_TYPE_TITLE,count(I.GOODS_TYPE_TITLE) from ICOM_GOODS_TYPE_TABLE I group by I.
2012-11-21 11:29:22 3221
转载 oracle sign函数解决大于小于的decode写法
select decode(sign(colA - colB) , -1 , colA + colB , colA) from table_namesign函数返回-1 , 0 , 1分别标识小于 , 等于 , 大于。
2012-11-17 09:31:23 15536
转载 Oracle 获取两个时间间隔天数
select trunc(时间1- 时间2) from table_name;时间1和时间2必须是date类型 如果不是必须to_date;
2012-11-05 12:23:03 7051
转载 ORA-28056: Writing audit records to Windows Event Log failed 解决
今天在TOAD里删除了一个作废的用户结果登陆时报ORA-28056: Writing audit records to Windows Event Log failed异常C:\Documents and Settings\Administrator>sqlplus /nologSQL*Plus: Release 11.2.0.2.0 Production on Thu Nov 1
2012-11-01 10:11:37 537
javascript动态行(代码清晰易懂)
2009-03-19
ibatis学习总结
2008-11-20
thinkphp扩展配置目录extra下配置文件内容是安全的吗?能否被外部访问到?
2022-06-14
TA创建的收藏夹 TA关注的收藏夹
TA关注的人