ORACLE建表样例

ORACLE数据库建表：

----------create table

CREATE TABLE MMS_APP_ORDER_INFO (

ID_APP_ORDER_INFO VARCHAR2(50) DEFAULT SYS_GUID() NOT NULL,

DEVICEID VARCHAR2(50) NOT NULL,

LOGIN_APP_ORDER VAECHAR2(1000) NOT NULL,

CREATED_BY VARCHAR2(100) NOT NULL ,

UPDATED_BY VARCHAR2(100) NOT NULL ,

DATE_CREATED DATE NOT NULL ,

DATE_UPDATED DATE NOT NULL

);

--------ADD COMMENTS TO THE TABLE

COMMENT ON TABLE MMS_APP_ORDER_INFO IS 'APP排序信息表';

--------ADD COMMENTS TO THE COLUMNS

COMMENT ON COLUMN MMS_USER_APP_INFO.ID_APP_ORDER_INFO IS '编号';

COMMENT ON COLUMN MMS_USER_APP_INFO.DEVICEID IS '设备ID';

COMMENT ON COLUMN MMS_USER_APP_INFO.LOGIN_APP_ORDER IS '设备已登陆APP顺序（倒叙）';

COMMENT ON COLUMN MMS_USER_APP_INFO.DATE_CREATED IS '创建时间';

COMMENT ON COLUMN MMS_USER_APP_INFO.CREATED_BY IS '创建人';

COMMENT ON COLUMN MMS_USER_APP_INFO.DATE_UPDATED IS '更新时间';

COMMENT ON COLUMN MMS_USER_APP_INFO.UPDATED_BY IS '更新人';

---------create index

CREATE UNIQUE INDEX MAAMDATA.PK_MMS_APP_ORDER_INFO ON MAAMDATA.MAAM_APP_ORDER_INFO(ID_APP_LOGIN_INFO);

ALTER TABLE MAAMDATA.MAAM_USER_APP_INFO ADD CONSTRAINT PK_MAAM_APP_ORDER_INFO PRIMARY KEY(ID_APP_LOGIN_INFO) USING INDEX PK_MAAM_APP_ORDER_INFO;

--------create synonym(同义词)

CREATE PUBLIC SYNONYM MAAM_APP_ORDER_INFO FOR MAAMDATA.MAAM_APP_ORDER_INFO;

------create privilege (权限) 使用GRANT命令

GRANT SELECT, INSERT, DELETE, UPDATE ON MAAMDATA.MMS_APP_ORDER_INFO TO DONGHAIHUA;

GRANT SELECT ON HMRPTDATA.WIDETABLE_APPID_DEVICEID TO MAAMDATA,DONGHAIHUA;