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

How do I view tables in sql developer?

943

What is record type in pl sql?

991

how mysql optimizes distinct? : Sql dba

1079

Can dml statements be used in pl/sql?

1078

how to extract a unit value from a date and time? : Sql dba

990

What is t-sql? : Transact sql

984

Mention what are the benefits of pl/sql packages?

1080

What are the popular database management systems in the it industry?

999

What is sql and how does it work?

1171

What are all the different types of indexes?

1147

What is trigger point?

994

What is pessimistic concurrency control? : Transact sql

1086

Can a trigger call a stored procedure?

1070

What is mutating table error?

1178

What is meant by temporal data?

969