If table is empty (means no records are there) then we can add the constr

If we have n no of columns in a table, can we add new
column in that table with not null constraint?

Question Posted / chandan kumar

Answer Posted / chandan kumar

If table is empty (means no records are there) then we can
add the constraint.

alter table tablename add (col_name datatype not null)

Is This Answer Correct ?

6 Yes

2 No

Please Help Members By Posting Answers For Below Questions

How do I clear the screen in sql plus?

982

Can we use joins in subquery?

1086

What is a join query?

905

What is on delete set null?

1037

Is sql a case sensitive language?

891

What is record type in pl sql?

935

What is a sql select statement?

994

What is sql*loader and what is it used for?

1044

What is the difference between cluster and non-cluster index?

1046

how to extract a unit value from a date and time? : Sql dba

945

what is commit? : Sql dba

1026

what are the advantages of mysql in comparison to oracle? : Sql dba

939

What does varchar include?

905

Which type of cursor is used to execute the dml statement?

894

Does sql*plus also have a pl/sql engine?

1037