- 博客(9)
- 资源 (3)
- 收藏
- 关注
RSS订阅原创 触发器对本表操作
CREATE OR REPLACE TRIGGER testbefore UPDATE OR INSERT OF BODYPART ON T_PROCEDURE_testFOR EACH ROWdeclarea varchar2(256);BEGINselect min(MODALITYS) into a from t_order_test where orderidentity=:n
2015-03-02 22:57:26
1176
原创 查询某个table关联的所有外键
--查询table(TGP_RPT_GPR0042MY_D1)关联的所有外键select fk_col.constraint_name, fk_col.table_name, fk_col.column_name from user_constraints pk, user_constraints fk, user_cons_columns fk_colwhere pk.
2014-12-04 18:19:12
425
原创 MYSQL从零开始 -- 时间分割（存储过程）
DELIMITER //create procedure test(in pi_begin_time datetime,in pi_end_time datetime)beginDECLARE l_start_dt datetime;DECLARE l_end_dt datetime;DECLARE l_date datetime;DECLARE l_str varchar(30);
2014-11-10 20:38:29
767
1
原创 通过在触发器中建立自治事务解决ORA-04091(不能读取被触发的表)
create table t1(id number,nm varchar2(100));create table t2(id number,nm varchar2(100)); insert into t2 values(1,'n1'); CREATE OR REPLACE TRIGGER test before update ON t1 FOR EACH ROWdeclare
2014-10-22 16:38:53
491
原创 grouping and grouping_id
--grouping值为0时说明这个值是数据库中本来的值，为1说明是统计的结果(也可以说该列为空时是1，不为空时是0)，with t as (select 1 id, 'A' class_id, 10 amt from dual union all select 2 id, 'A' class_id, 20 amt from dual union all sel
2014-10-21 14:57:03
408
原创 function返回sys_refcursor
function:createorreplacefunction sql_test (sql_strvarchar2)returnSYS_REFCURSORis po_return sys_refcursor;begin open po_returnfor sql_str; return(po_return);e
2014-09-03 20:30:45
864
原创 相同间隔分组
WITH test AS(SELECT 1 ID FROM dual UNION ALL SELECT 2 ID FROM dual UNION ALLSELECT 5 ID FROM dual UNION ALLSELECT 6 ID FROM dual UNION ALLSELECT 7 ID FROM dual UNION ALLSELECT 9 ID FROM dual
2013-12-12 17:04:35
580
原创 常见SQL(生成序列号)
Test data：Code:select ltrim(MAX(SYS_CONNECT_BY_PATH(rn, '-')), '-') col, t2.id, t2.pid from (select t1.*, ROW_NUMBER() OVER(PARTITION BY c_level, PID ORDER BY ID) AS RN
2013-11-14 21:00:31
1658
虚拟机安Linux详解
2011-01-10
空空如也
TA创建的收藏夹 TA关注的收藏夹
TA关注的人