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 to get each name only once from an employee table?

1071

What is an escape character in sql?

986

How long does it take to learn pl sql?

1010

What is pl sql collection?

924

How do you use a while loop in pl sql?

949

What is difference between my sql and sql?

1007

How do you optimize a stored procedure query?

948

What does fetching a cursor do?

1030

How do I remove sql developer from windows 10?

1028

is it possible to pass an object or table to a procedure as an argument?

1071

What is the main difference between sql and pl/sql?

1037

What are sql objects?

1028

What is the basic form of sql query?

891

Where not exists in sql?

924

What does the base_object_type column shows in the user.triggers data dictionary view?

1003