alter the table -> alter table <table name> <datatype> afte

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 / jyothi

9 Answers
12001 Views
I also Faced
E-Mail Answers

Answer Posted / jyothi

alter the table -> alter table <table name> <datatype>
after then u can insert values in that clounm bu using
UPDATE ...
update set column name= value where condition
condition ....where u want to update the value means which
row...

Is This Answer Correct ?

0 Yes

0 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

Does sql profiler affect performance?

994

What is the difference between Union and Union all. Which is faster.

1403

How do I count rows in sql query?

990

how to enter numeric values as hex numbers? : Sql dba

1064

What is a composite primary key?

1095

what is 'mysqlshow'? : Sql dba

1027

What is pl sql variable?

991

What are operators available in sql?

1048

Which sql most popular?

991

What is rownum?

982

Is sql a oracle?

981

What is the difference between nested table and varray?

1003

What jobs use sql?

982

Is a secondary key the same as a foreign key?

1038

Explain exception handling in pl/sql?

1037