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
12002 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 views in sql?

989

How to fix oracle error ora-00942: table or view does not exist

1016

How to assign sql query results to pl sql variables?

1081

What does joining a thread mean?

1021

How do I kill a query in postgresql?

1130

Where not exists in sql?

980

What are the sql commands?

1181

What are stored procedures in mysql?

1019

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

1153

Is sql the best database?

976

Is sql harder than python?

1108

Is primary key clustered index?

950

Can we use pl sql in mysql?

1013

Explain the components of sql?

1064

What are keys in sql?

1000