alter table <table-name> add(<column-name> datatype [constrain

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

Answer Posted / srinivas

alter table <table-name> add(<column-name> datatype
[constrains]);

Is This Answer Correct ?

0 Yes

0 No

Please Help Members By Posting Answers For Below Questions

What is a temporal data type?

1027

Can we insert in view in sql?

1037

What are aggregate functions in sql?

1139

What is constant in pl sql?

1005

Is sql dba a good career? : SQL DBA

975

What is data profiling in sql?

1056

What are system versioned tables?

1010

What are basic techniques of indexing?

1361

How can a function retun more than one value in oracle with proper example?

1061

What is record data type?

900

what happens if null values are involved in expressions? : Sql dba

1029

Is it possible to create the following trigger: before or after update trigger for each row?

1273

What is the use of count (*) in sql?

1031

what are the differences between require and include, include_once and require_once? : Sql dba

1008

What is query execution plan in sql?

1167