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

Is record in pl sql?

517

What is the difference between pl and sql?

545

Explain the savepoint statement.

604

How do I find duplicates in sql?

511

Should I use mbr or gpt?

546

how to drop an existing table in mysql? : Sql dba

560

how to create a new view in mysql? : Sql dba

503

Why we use pl sql?

531

How do I run a pl sql program?

630

How to raise user-defined exception with custom sqlerrm ?

682

What is posting?

611

What is normalization in sql?

530

what is data integrity? : Sql dba

596

What is rownum?

544

What is rtm in testing?

580