Expert: Peter Choi - 6/20/2009

Question
While creating table, there is options like allow null or not, similarly is it possible to implement option like allow zero length or not.If possible,  what is the SQL syntax to implement it. Especially using alter statement for multiple columns.

Thank you.

Answer
Hi Saravanan,

You may wish to consult the Oracle 10gR2 CREATE TABLE reference: http://download.oracle.com/docs/cd/B19306_01/server.102/b14200/statements_7002.h...

While there are options for null or not null columns, there is not 0 length or non-zero length option.

For the syntax and allowable parameters using the ALTER TABLE syntax:

http://download.oracle.com/docs/cd/B19306_01/server.102/b14200/statements_3001.h...

Hope this helps.

Peter