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
12290 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 are the advantages of sql ? : Sql dba

1111

What is the difference between null value, zero, and blank space?

1257

Can there be more than one function with a similar name in a pl/sql block?

1044

What is right join in sql?

1158

Which is faster subquery or join?

1274

Can we use pl sql in mysql?

1063

What is sql injection vulnerability?

1005

what is sub-query? : Transact sql

1161

What is set transaction?

1090

What is the purpose of cursors in pl/sql?

1204

Can you inner join the same table?

1039

What problem one might face while writing log information to a data-base table in pl/sql?

1250

What is a relationship and what are they?

1230

What are sql indexes?

1047

Describe types of sql statements?

1107