章 波的专栏

<br />create or replace trigger trg_jx0408<br />before insert or update or delete on jx0408<br />for each row<br />declare<br />ary_kkzcmx t_varray;--申明数组保存kkzcmx<br />ary_kcsjmx t_varray;--申明数组保存kcsjmx<br />t_rxnf varchar2(4);<br />begin<br />    if inser

select o.name, c.name, co.comment$ ---表明，字段名，字段注释 from sys.obj$ o, sys.col$ c, sys.com$ co where o.owner# = userenv('SCHEMAID') and o.type# in (2, 4) and o.obj# = c.obj# and c.obj# = co.obj

create or replace trigger tr_ckyjqbxx_bjxxjl before insert or update of SJQSZT on dtjf.t_zt_zdry_cklkyjqbxx for each row --常控临控预警触发报警信息 d

create or replace function F_FORMAT_DATE(v_date varchar2,format varchar) /* 时间格式处理格式 */ return date as v_endDate date;

oralce函数大全ABS<br />返回指定值的绝对值<br />SQL> select abs(100),abs(-100) from dual;<br /> ABS(100) ABS(-100)<br />--------- ---------<br />      100       100ACOS<br />给出反余弦的值<br />SQL> select acos(-1) from dual;<br /> ACOS(-1)<br />---------<br />3.1415927ADD_MON

<br />/*<br />  数字转大写<br />   20081218 CLINTON<br />*/<br />CREATE OR REPLACE FUNCTION F_NUM_UPPER   (sz number)<br />return varchar2 is<br />szdx varchar2(100);<br />lszf varchar2(100);<br />zf varchar2(100);<br />qsz varchar2(1);<br />i number;<br />j nu

<br />---定时器 declare job number; begin sys.dbms_job.submit(job, what => 'p_test;', next_date => to_date('22-10-2008 10:06:41', 'dd-mm-yyyy hh24:mi:ss'), interval => 'sysdate+1/1440'); --每天1440分钟，即一分钟运行test过程 一次

create or replace procedure deleteLgZS is cursor getList is select ryid from qbzhpt.t_ys_ry a where a.ywgl='0000000100000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000' ; type getRyIDLIST is table of getList%rowtype

<br /><br /> (<br />                 select wmsys.wm_concat(distinct xx04.bj) ---wmsys.wm_concat(distinct  字段名)<br />                 from kw0406 b<br />                 left join kw0407 on kw0407.kw0406id =b.id<br />                 left join xx04 on xx04

rollup   配合   goup   by   命令使用，可以提供信息汇总功能（类似于"小计"）     下面是一个简单例子：   SQL> select job,deptno,sal from emp; JOB DEPTNO SAL --------- ----