hi Alter Table <Table Name> ADD( <Column name> <data ty

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 / ramprasad.s

9 Answers
11677 Views
I also Faced
E-Mail Answers

Answer Posted / ramprasad.s

hi

Alter Table <Table Name> ADD( <Column name> <data type>)

you can insert values by using <update> with reference

to the existing values of the other columns.
bye

sun_ramprasad@yahoo.com

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 a composite key ? : Sql dba

993

Is grant a ddl statement?

850

Can we insert in view in sql?

1000

What does the hierarchical profiler does?

1002

How to start oracle sql developer?

983

What is an index? What are the types of indexes? How many clustered indexes can be created on a table?

992

How do you sort in sql?

948

In what condition is it good to disable a trigger?

967

What is numeric function sql?

983

How can a function retun more than one value in oracle with proper example?

1025

what tools available for managing mysql server? : Sql dba

1006

What is Histogram?

1503

What is data types in sql?

947

How to test for null values?

980

how to write date and time literals? : Sql dba

912