使用oracle数据库建表语句,oracle运用(二) oracle数据库完整建表语句

--判断表是否存在，如果存在则删除

declare

num number;

begin

select count(1) into num from all_tables where TABLE_NAME = 'LOGISTICS_SUGGESTION'; -- and OWNER='SCOTT'

if num=1 then

execute immediate 'drop table LOGISTICS_SUGGESTION';

end if;

end;

-- Create table

CREATE TABLE LOGISTICS_SUGGESTION

(

id NUMBER not null,

industry_id NUMBER,

contact_name VARCHAR2(128),

contact_phone VARCHAR2(128),

handle_statusVARCHAR2(32),

suggestion_remark VARCHAR2(500),

handle_remark VARCHAR2(500),

create_time DATE default sysdate,

handle_time DATE

);

--指定表空间(可以不指定)

tablespace DSW

pctfree 10

pctused 40

initrans 1

maxtrans 255

storage

(

initial 64K

minextents 1

ma