Define Not Null column on <createTable> tag

General Discussion
1

Hello,

 

I would be very grateful if someone can tell me how I can define a Not NULL column within a command. For example  I have the following XML to create a table which works fine :-

 


           <column name=“ACCOUNT_TYPE_ID” type=“NUMBER(22)”  />
          
          

 

But the ACCOUNT_TYPE_ID column needs to be defined as NOT NULL here.

 

Struggling to find a clear example on how to do this.

 

Thanks,

Shaun.

2

OK sorted it myself , solution was :-

 

 

Great ‘documentation’ guys !