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 to get a list of all tables in a database? : Sql dba

513

What is sql key?

525

Can %notfound return null after a fetch?

593

What is not in sql?

502

Is sql easier than java?

529

What is information schema in sql?

584

What is the difference between the conventional and direct path loads? : aql loader

700

What is the difference between nested table and varray?

525

How many types of primary keys are there?

533

what is a database? : Sql dba

612

What is mutating table error?

666

Which command is used to call a stored procedure?

505

What are the conditions an underlying table must satisfy before a cursor can be used by a positioned update or delete statement? : Transact sql

543

What is a join?

628

Is sql pronounced sequel or sql?

749