alter table table_name add c4 varchar2(30) default null

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 / premraj

Answer Posted / premraj

Is This Answer Correct ?

2 Yes

0 No

Please Help Members By Posting Answers For Below Questions

Is trigger a stored procedure?

921

Which command is used to delete a package?

1148

What are the ddl commands?

989

Is ms sql is free?

1007

What is mutating table error?

1155

How would you reference column values before and after you have inserted and deleted triggers?

1047

What is nvarchar max in sql?

994

how to convert dates to character strings? : Sql dba

1141

What does sql stand for?

974

Can we insert delete data in view?

935

what is a view? : Sql dba

1064

What is the cause of mutating table error and how can we solve it?

1035

What are two statement types in sql?

1064

Differentiate between % rowtype and type record.

1277

What is the difference between function, procedure and package in pl/sql?

1221