2021-03-27oracle创建表

CREATE TABLE T_SYS_表的名称
(

主键ID VARCHAR2(36) default sys_guid() not null,

last_updated_date TIMESTAMP(6) default systimestamp not null,
update_control_id VARCHAR2(36) default sys_guid() not null,

);
– Add comments to the table
COMMENT ON TABLE LG.T_SYS_表的名称
IS ‘表的备注’;
– ADD COMMENTS TO THE COLUMNS
COMMENT ON COLUMN T_SYS_表的名称.主键ID
IS ‘表的字段的备注’;