MrLisky的博客

create or replace procedure p_isof_exists_sequence(v_tablename in varchar2)asv_cnt number(1);v_sql varchar2(100);cursor c_seqname is --将表名暂替换成序列名填入到变量 v_Seqname,v_Seqname_2,v_Seqname...

1.Oracle方法 判断是否是日期CREATE OR REPLACE FUNCTION is_date (parmin VARCHAR2) RETURN NUMBER ISval DATE; BEGIN val := TO_DATE (NVL (parmin, 'a'), 'yyyy-MM-dd');RETURN 1; EXCEPTIONWHEN OTHERSTHEN RET...

CREATE OR REPLACE TRIGGER TRI_Mg_LockShares before insert or update on TBL_CHN_T_Mg_LockShares for each rowdeclare msgNum number(10);begin --InstitutionID 上市公司ID if INSERTING then se...

CREATE OR REPLACE TRIGGER TRI_MG_CSHAREHOLD before insert or update on TBL_CHN_T_Mg_Csharehold for each rowdeclare msg number(10); value1 NUMBER(2); SumShares1 NUMBER(20, 2);b...