How can we add a column to a table without altering the
same?
Answer Posted / sanjay rawat
In oracle,
1. take data in new table from existing table
2. add a new column in new table by using alter command
3. drop existing table
4. rename new table with existing table name
5. Check by select query
Is This Answer Correct ? | 1 Yes | 3 No |
Post New Answer View All Answers
Is sybase free?
What are the best monitoring tools for the sybase database?
What is the command for quitting from sybase?
How to start and stop sybase database in linux sap?
Explain timestemp datatype in sybase.
What you need to do is issue an ase kill command on the connection then un-suspend the db?
Differentiate between db-lib and ct-lib?
explain engines?
State some of the products of sybase?
How does sybase replication work?
How do I capture a process s sql in sybase?
What are table partitions? How is it different with ase 15.0 version?
What is the use of sp_helprotect in sybase?
List similarities and differences between oracle & sybase.
How do I configure identities in sybase?