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
- 9 Answers
- 9658 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
What language is oracle sql developer?
Which version of sql do I have?
What is the difference between explicit and implicit cursors in oracle?
What is sql performance tuning?
Explain raise_application_error.
How does join work in sql?
Name some usages of database trigger?
What are the advantages of normalization?
how is exception handling handled in mysql? : Sql dba
What are stored procedures in mysql?
what is a composite primary key ? : Sql dba
Why sql query is slow?
Is the primary key an index?
what are date and time functions in mysql? : Sql dba
What is a table?
