ALTER TABLE DUMMY1 ADD (C4 VARCHAR2(100) DEFAULT 0)

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

Answer Posted / asraf

Is This Answer Correct ?

1 Yes

0 No

Please Help Members By Posting Answers For Below Questions

What is mutating table error?

1155

What is the use of & in pl sql?

1030

Can you selectively load only those records that you need? : aql loader

1023

what is the difference between char_length and length? : Sql dba

1026

What is pl sql and why it is used for?

1098

Is pl sql useful?

966

How many row comparison operators are used while working with a subquery?

1016

What is sequence in sql?

986

Does a user_objects view have an entry for a trigger?

1000

What are the benefits of stored procedures?

1046

What is user defined functions?

954

Is sql developer case sensitive?

978

Does truncate table reset auto increment?

977

Explain the methods used to protect source code of pl/sql.

1006

how to enter binary numbers in sql statements? : Sql dba

952