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 are the authentication modes in sql server? : Sql dba

995

Can you skip header records while loading? : aql loader

968

What is oracle pl sql developer?

931

Where the sql database files are stored?

951

What does seeding a database mean?

888

What is the usage of the distinct keyword?

1162

Does sql*plus have a pl/sql engine?

994

List the different type of joins?

993

What are the types of queries in sql?

1010

how can you create an empty table from an existing table? : Sql dba

1076

Why trigger is used in sql?

912

Mention what is the function that is used to transfer a pl/sql table log to a database table?

929

List the ways to get the count of records in a table?

851

What are system versioned tables?

963

What do you mean by stored procedures? How do we use it?

927