Oracle_J_添加新表 

 1 --判断表是否存在，如果存在则删除
 2 DECLARE 
 3       NUM   NUMBER; 
 4 BEGIN 
 5       SELECT COUNT(1) INTO NUM FROM ALL_TABLES WHERE TABLE_NAME = 'SELECT_ORDER' AND OWNER='ZYLIS'; 
 6       IF   NUM>0   THEN 
 7           EXECUTE IMMEDIATE 'drop table ZYLIS.SELECT_ORDER'; 
 8       END   IF; 
 9 END; 
10 / 
11 CREATE TABLE SELECT_ORDER
12        (APP_DOC_ID VARCHAR2(30),
13         ORDER_ID NUMBER(18,0),
14         ORDER_NO NUMBER(10,0),
15         INPUT_CODE VARCHAR2(100))
16 TABLESPACE LIS_SPACE;
17 COMMENT ON TABLE  SELECT_ORDER IS '项目频率排序表';
18 COMMENT ON COLUMN SELECT_ORDER."APP_DOC_ID"  IS '申请医生编号';
19 COMMENT ON COLUMN SELECT_ORDER."ORDER_ID"  IS '医嘱字典编号';
20 COMMENT ON COLUMN SELECT_ORDER."ORDER_NO"  IS '排序号';
21 COMMENT ON COLUMN SELECT_ORDER."INPUT_CODE"  IS '简拼';
22 COMMIT;

 

posted @ 2016-04-07 13:25  阆苑仙葩  阅读(156)  评论(0)    收藏  举报