Alter table tablename ADD(columnname (data

I have one table and column is c1 pk, c2 not null,c3 not
null and 200 row in it and i add c4 column and value, how
can is possible

Question Posted / gayathri

Answer Posted / gayathri

Alter table tablename ADD(columnname (data_type) notnull)

Is This Answer Correct ?

0 Yes

0 No

Please Help Members By Posting Answers For Below Questions

what is offset-fetch filter in tsql? : Transact sql

940

Explain what is a subquery ?

1182

What is row_number () in sql?

978

what happens if null values are involved in expressions? : Sql dba

1037

How delete a row in sql?

987

What is the life of an sql statement?

1015

How many types of indexes are there in sql?

978

What is procedure and function in sql?

992

Define sql delete statement.

1003

What is column?

981

What is package in pl sql with an examples?

1035

what is commit? : Sql dba

1067

what is not null constraint? : Sql dba

1023

What is the difference between functions, procedures, and packages in pl/sql?

1040

Why are cursors used?

1114