2020-02-16 标签:oracle,触发器,使用,小结,递增,序列,create,sequence,lzeam,sp,loop,eq,seq,minvalue,increment,start,测试,select

--建递增序列 CREATE SEQUENCE LZEAM_SP_LOOP_EQ_SEQ MINVALUE 1 INCREMENT BY 1 START WITH 1 测试: SELECT LZEAM_SP_LOOP_EQ_SEQ.NEXTVAL FROM DUAL --建触发器 CREATE OR

2020-02-16 标签:oracle,函数,大全,sql,记录,ascii,返回,指定,字符,对应,十进制,select,a,zero,space,dual

SQL中的单记录函数 1.ASCII 返回与指定的字符对应的十进制数; SQL> select ascii('A') A,ascii('a') a,ascii('0') zero,ascii(' ') space from dual; A A ZERO SPACE --------- ----

2020-02-16 标签:sql,返回,期间,内的,日期,实现,代码,如下,select,rownum,dateindex,date,20090701,yyyy,mm,dd,dual,connect,level

实现代码如下：select rownum as dateIndex,to_date('20090701','yyyy-mm-dd')+ rownum-1 AS DATE_ FROM DUAL CONNECT BY LEVEL >= 1 AND LEVEL <=(TO_DATE('2009

2020-02-16 标签:oracle,函数,大全,字符串,数学,日期,sql,记录,ascii,返回,指定,字符,对应,十进制,select,a

SQL中的单记录函数 1.ASCII 返回与指定的字符对应的十进制数; SQL> select ascii('A') A,ascii('a') a,ascii('0') zero,ascii(' ') space from dual; A A ZERO SPACE --------- ----