Oracle creates tables and adds comments

To create a database table, add a comment method:

Create Table Warningrecord (    varcharprimarykeynotnull  oncolumnis' alarm number ';

Now you want to execute it through a PL/SQL statement block, the following code:

DeclareTableexist Number;begin    Select Count(1) intoTableexist fromAll_tableswheretable_name='Warningrecord'; ifTableexist>0  Then        ExecuteImmediate'drop table Warningrecord'; return; End if; ExecuteImmediate'CREATE TABLE Warningrecord (RecordID varchar (PRIMARY) KEY not NULL)'; ExecuteImmediate'COMMENT on COLUMN warningrecord.recordid is"'Alarm number" ";End;

Oracle creates tables and adds comments