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 join an inner join?

976

What are the different types of database management systems?

1001

What is oracle and pl sql?

1118

Can we commit inside a trigger?

994

What is update query?

983

Why do we use procedures?

958

What are the set operators in sql?

1072

Does mysql_real_escape_string prevent sql injection?

949

Is there any restriction on the use of union in embedded sql?

1157

What is linq to sql?

1132

how to decrement dates by 1 in mysql? : Sql dba

1020

Can a foreign key be null?

1091

Why we use pl sql?

962

What is bulk collect in pl sql?

1089

What is the use of function "module procedure" in pl/sql?

1198