Oracle 存储过程的问题

Question

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 '告警编号';

Answer 1

嗯你再试试 或许能成功