1. alter table <table_name> add column<col_name> <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 / manoj

9 Answers
11880 Views
I also Faced
E-Mail Answers

Answer Posted / manoj

1.
alter table <table_name>
add column<col_name> <data_type>[not null];

2.
for inserting values

Depends: if u have data in another table than u can insert
by making small packege (using cursor)

OR :u can also sequence to insert

Is This Answer Correct ?

2 Yes

0 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

What is a table?

999

Which data type is a composite type?

973

how to enter binary numbers in sql statements? : Sql dba

952

What is the difference between having clause and where clause?

1046

Does sqlite need a server?

1031

Is left join inner or outer?

1000

How do you go back in sql?

973

What is full join?

931

What is assignment operator in pl sql?

1015

What is indexes?

1046

what is meant by nl2br()? : Sql dba

1010

What operating systems are supported by oracle sql developer?

937

What is varchar data type in sql?

1060

What is difference between my sql and sql?

1044

Which one is better subquery or joins?

1039