Alter table tablename ADD(columnname (data

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

Answer Posted / gayathri

Alter table tablename ADD(columnname (data_type) notnull)

Is This Answer Correct ?

0 Yes

0 No

Please Help Members By Posting Answers For Below Questions

Is sql open source?

953

What is a sql*loader control file?

1231

Where is all the data on the internet stored?

987

Can we use joins in subquery?

1141

Is pl sql and postgresql same?

1100

Does sqlite need a server?

1031

Are there any features that are decommissioned in 11g that are not present in 11g?

2124

What are the different types of a subquery?

1031

What are the different schemas objects that can be created using pl/sql?

1003

Mention what does the hierarchical profiler does?

1065

what is auto increment? : Sql dba

992

What are sql constraints?

1159

What is the difference between the repeatable read and serializable isolation levels? : Transact sql

1074

Is null operator in sql?

1012

what is a constraint? : Sql dba

1125