Oracle
qq1988627
这个作者很懒,什么都没留下…
展开
-
创建自动增长ID以及查询当前ID和下一个ID
[code="java"]DROP SEQUENCE PLAN.PLAN_MAINTAIN_LOG_S; CREATE SEQUENCE PLAN.PLAN_MAINTAIN_LOG_S START WITH 1 MAXVALUE 999999999 MINVALUE 1 NOCYCLE NOCACHE NOORDER; ...原创 2011-11-18 10:07:39 · 143 阅读 · 0 评论 -
创建JOB
CREATE OR REPLACE PROCEDURE METERIAL.RUNDAILYBYJOB AS VAR_COUNT INTEGER; VAR_DATE VARCHAR2(20); CURSOR cur_location is select * from mate_location_info; BEGIN VAR_DATE:=TO_CHAR(SYSD...原创 2011-11-18 10:12:06 · 87 阅读 · 0 评论 -
创建存储过程
[code="java"]CREATE OR REPLACE PROCEDURE METERIAL.MATE_SCRAP_ACTION( MESAGE OUT TCURSOR.curvar_type, VAR_FEEDNUM IN VARCHAR2, VAR_ITEMNAME IN VARCHAR2, VAR_FOLDADDRESS IN VARCHAR2, VAR...原创 2011-11-18 10:15:22 · 73 阅读 · 0 评论