现有表dat_group_send_log结构如下,请问建立这个表的SQL语句怎么写?NameNull?Type-----------------------------------------------------------------------------SESSION_IDNOTNU...
现有表dat_group_send_log结构如下,请问建立这个表的SQL语句怎么写?
Name Null? Type
----------------------------------------- -------- ----------------------------
SESSION_ID NOT NULL VARCHAR2(32)
WORK_FLOW_ID VARCHAR2(32)
MESSAGE_ID VARCHAR2(32)
TASK_ID NOT NULL VARCHAR2(32)
CALLING_ID NOT NULL VARCHAR2(32)
CALLED_ID NOT NULL VARCHAR2(32)
CALLED_STATUS VARCHAR2(32)
CALLED_AREA_CODE VARCHAR2(8)
CALLED_NET_ID VARCHAR2(32)
CONTENT_CODE NOT NULL VARCHAR2(32)
CONTENT_NAME VARCHAR2(64)
CONTENT_CATEGORY_ID VARCHAR2(32)
CONTENT_CATEGORY_NAME VARCHAR2(64)
MT_MESSAGE VARCHAR2(512)
MT_TIME NOT NULL DATE
SEND_TIME NOT NULL DATE
SEND_RESULT VARCHAR2(32)
CHARGE_CODE VARCHAR2(10)
CHARGE_TYPE VARCHAR2(2)
FEE NUMBER(38)
REPORT_TIME DATE
REPORT_CODE VARCHAR2(10)
INSERT_TIME NOT NULL DATE
展开