作者：风光好风光好啊_229 | 来源：互联网 | 2014-07-13 17:52
DECLAREiCountnumber(2):0;BEGINSELECTCOUNT(*)INTOiCountFROMuser_sequencesuWHEREu.sequence_name'SEQ_TCAPITALNOTIFY';www.2cto.comIFiCount0...
DECLARE
iCount number(2) := 0;
BEGIN
SELECT COUNT (*) INTO iCount FROM user_sequences u WHERE u.sequence_name = &＃39;SEQ_TCAPITALNOTIFY&＃39;; www.2cto.com
IF iCount = 0
THEN
/*创建序列*/
EXECUTE IMMEDIATE &＃39;create sequence SEQ_TCAPITALNOTIFY minvalue 1 nomaxvalue start with 1 increment by 1&＃39;;
END IF;
SELECT COUNT (*) INTO iCount FROM user_tables u WHERE u.TABLE_NAME = &＃39;TCAPITALNOTIFY&＃39;;
IF iCount = 0
THEN
/*创建表TCAPITALNOTIFY*/
EXECUTE IMMEDIATE &＃39;create table TCAPITALNOTIFY(
L_SERIALNO number(11) not null primary key,
D_DATE DATE not null,
C_CUSTNO varchar2(12) not null,
F_BALENCE NUMBER(16,2),
C_FUNDCODE VARCHAR2(6),
D_REPLYPAYTIME DATE,
C_ORGCONTACT VARCHAR2(2000),
C_ORGTEL VARCHAR2(2000),
D_NOTIFICATIONTIME DATE,
C_ISCERTIFICATE CHAR(1),
C_REALPAYTIME DATE,
C_MEMO CHAR(1),
C_ISCANCEL VARCHAR2(2000),
C_CREATOR VARCHAR2(16),
D_CREATEDATE DATE
) nologging tablespace crm_htable&＃39;; www.2cto.com
EXECUTE IMMEDIATE &＃39;comment on table TCAPITALNOTIFY is &＃39;&＃39;资金通知情况表&＃39;&＃39;&＃39;;
EXECUTE IMMEDIATE &＃39;comment on column TCAPITALNOTIFY.L_SERIALNO is &＃39;&＃39;序列号&＃39;&＃39;&＃39;;
EXECUTE IMMEDIATE &＃39;comment on column TCAPITALNOTIFY.D_DATE is &＃39;&＃39;日期&＃39;&＃39;&＃39;;
EXECUTE IMMEDIATE &＃39;comment on column TCAPITALNOTIFY.C_CUSTNO is &＃39;&＃39;账户名称&＃39;&＃39;&＃39;;
EXECUTE IMMEDIATE &＃39;comment on column TCAPITALNOTIFY.F_BALENCE is &＃39;&＃39;购买资金（元）&＃39;&＃39;&＃39;;
EXECUTE IMMEDIATE &＃39;comment on column TCAPITALNOTIFY.C_FUNDCODE is &＃39;&＃39;购买产品&＃39;&＃39;&＃39;;
EXECUTE IMMEDIATE &＃39;comment on column TCAPITALNOTIFY.D_REPLYPAYTIME is &＃39;&＃39;机构答复资金划拨时间&＃39;&＃39;&＃39;;
EXECUTE IMMEDIATE &＃39;comment on column TCAPITALNOTIFY.C_ORGCONTACT is &＃39;&＃39;机构联系人&＃39;&＃39;&＃39;;
EXECUTE IMMEDIATE &＃39;comment on column TCAPITALNOTIFY.C_ORGTEL is &＃39;&＃39;机构联系电话&＃39;&＃39;&＃39;;
EXECUTE IMMEDIATE &＃39;comment on column TCAPITALNOTIFY.D_NOTIFICATIONTIME is &＃39;&＃39;我方通知时间&＃39;&＃39;&＃39;;
EXECUTE IMMEDIATE &＃39;comment on column TCAPITALNOTIFY.C_ISCERTIFICATE is &＃39;&＃39;是否提供划款凭证&＃39;&＃39;&＃39;;
EXECUTE IMMEDIATE &＃39;comment on column TCAPITALNOTIFY.C_REALPAYTIME is &＃39;&＃39;资金实际到账时间&＃39;&＃39;&＃39;; www.2cto.com
EXECUTE IMMEDIATE &＃39;comment on column TCAPITALNOTIFY.C_ISCANCEL is &＃39;&＃39;撤单&＃39;&＃39;&＃39;;
EXECUTE IMMEDIATE &＃39;comment on column TCAPITALNOTIFY.C_MEMO is &＃39;&＃39;备注&＃39;&＃39;&＃39;;
EXECUTE IMMEDIATE &＃39;comment on column TCAPITALNOTIFY.C_CREATOR is &＃39;&＃39;创建人&＃39;&＃39;&＃39;;
EXECUTE IMMEDIATE &＃39;comment on column TCAPITALNOTIFY.D_CREATEDATE is &＃39;&＃39;创建日期&＃39;&＃39;&＃39;;
END IF;
END;
/
摘自 fujianianhua的专栏
京公网安备 11010802041100号