Oracle Create,Delete,Alter

----------------------Create Table--------------------------------
create table SMS_EXTERNALSYSSMSREQUEST
(
  SMSSENDRECID   VARCHAR2(20) primary key not null,
  SOURCEREF      NUMBER(38) not null,
  SURVEYSVCNO    VARCHAR2(30) not null,
  SURVEYNAME     VARCHAR2(30),
  SENDDATETIME   DATE,
  CREATEUSERID   VARCHAR2(10) not null,
  CREATEDATETIME DATE not null,
  CHANGEUSERID   VARCHAR2(10),
  CHANGEDATETIME DATE,
  CUSTID         VARCHAR2(144),
  ACCTID         VARCHAR2(144),
  SVCNO          VARCHAR2(144),
  SOURCEID       VARCHAR2(50),
  ADDITIONALINFO VARCHAR2(1000)
)
------------------------Alter Table-------------------------------------
Alter table SMS_GREYLIST
add(
    REQREFID NUMBER(38),
    SOURCECODE NUMBER(38) DEFAULT 0
)

Alter table SMS_GREYLIST
modify(
    REQREFID NUMBER(38),
    SOURCECODE NUMBER(38) DEFAULT 0
)

Alter table SMS_GREYLIST
drop(
    REQREFID,
    SOURCECODE
)
------------------------Drop Table------------------------------------------
Drop Table SMS_EXTERNALSYSSMSREQUEST

------------------------Define Sequence----------------------------------------

create Sequence SEQ_UNSUBREQ
increment by 1 --add count every time
start with 1
nomaxvalue
nocycle
cache 10;

-----------------------Add comments to the columns--------------------------
comment on column sms_aicrequest.REASON1   is ‘Survey Type‘

-----------------------Add comments to the columns--------------------------
comment on table TABLENAME  is ‘表的注释‘

Oracle Create,Delete,Alter

原文：http://www.cnblogs.com/ganting/p/5077105.html