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

Is nosql faster than sql?

972

Which version of sql do I have?

1000

What is the difference between mdf and ndf files?

1063

what is self join and what is the requirement of self join? : Sql dba

1078

What do you mean by field in sql?

1037

What is Difference Between Unique and Primary Key Constraints?

1060

Can we use joins in subquery?

1089

What are the commands used in sql?

1017

What is a call statement? Explain with an example.

953

What is a .db file?

928

how many sql dml commands are supported by 'mysql'? : Sql dba

1058

What is use of term?

1008

Is sql sequential or random?

983

How many disk partitions should I have?

942

Why plvtab is considered as the easiest way to access the pl/sql table?

1132