Want column to be NOT NULL when using CREATE TABLE .. AS SELECT...
401820Apr 25 2007 — edited Apr 25 2007Using the following,
create table TABLENAME
as
select
company,
to_char(sysdate,'YYYYMMDDhh24miss') last_update
from
COMPANIES;
I find the last_update is created as NULL (for the Null/NOT NULL check)
I believe it is not possible in 9i to alter the table to make a column NOT NULL.
Is there anything I can do in the creation of the table ?
Thanks