declare tableExist number;
begin
Select count(1) into tableExist from all_tables where TABLE_NAME='WARNINGRECORD';
if tableExist>0 then
return;
end if;
execute immediate 'CREATE TABLE WarningRecord
(
RecordID varchar(36) PRIMARY KEY NOT NULL
)';
end;
下面这句备注怎么能加到上面一起执行?
COMMENT ON COLUMN WarningRecord.RecordID IS '告警编号';