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
11681 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

What is sql query optimization?

1021

What is time based sql injection?

901

how many columns can be used for creating index? : Sql dba

897

Is primary key a clustered index?

910

How do I clear the screen in sql plus?

982

Is join an inner join?

896

What is auto increment?

935

What are sql queries used for?

978

What is a pragma statement?

1201

Is it important to partition hard disk?

965

What is a primary key? Explain

920

How subquery works in sql?

994

What's the procedure?

865

Which are sql * plus commands?

1039

How does pl sql work?

913