- 博客(9)
- 资源 (3)
- 收藏
- 关注
原创 触发器对本表操作
CREATE OR REPLACE TRIGGER test before UPDATE OR INSERT OF BODYPART ON T_PROCEDURE_test FOR EACH ROW declare a varchar2(256); BEGIN select min(MODALITYS) into a from t_order_test where orderidentity=:n
2015-03-02 22:57:26
1183
原创 查询某个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_col where pk.
2014-12-04 18:19:12
430
原创 MYSQL从零开始 -- 时间分割(存储过程)
DELIMITER // create procedure test(in pi_begin_time datetime,in pi_end_time datetime) begin DECLARE l_start_dt datetime; DECLARE l_end_dt datetime; DECLARE l_date datetime; DECLARE l_str varchar(30);
2014-11-10 20:38:29
780
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 ROW declare
2014-10-22 16:38:53
503
原创 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
420
原创 function返回sys_refcursor
function: create or replace function sql_test (sql_str varchar2) return SYS_REFCURSOR is po_return sys_refcursor; begin open po_return for sql_str; return(po_return); e
2014-09-03 20:30:45
869
原创 相同间隔分组
WITH test AS(SELECT 1 ID FROM dual UNION ALL SELECT 2 ID FROM dual UNION ALL SELECT 5 ID FROM dual UNION ALL SELECT 6 ID FROM dual UNION ALL SELECT 7 ID FROM dual UNION ALL SELECT 9 ID FROM dual
2013-12-12 17:04:35
589
原创 常见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
1670
虚拟机安Linux详解
2011-01-10
空空如也
TA创建的收藏夹 TA关注的收藏夹
TA关注的人