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
How would you fix a munged log in sybase ?
List different types of sybase index.
Is sybase open source?
A single operation is failing to escalate?
How to find the time taken for rollback of the processed?
Differentiate between db-lib and ct-lib?
How configure sybase odbc connection?
What do you mean by mainframe connect tool in sybase?
What is coalesce in sybase?
Why am I running out of locks on the replicate side in sybase ?
What are table partitions? How is it different with ase 15.0 version?
Explain procedure cache and data cache in sybase.
Who owns sybase?
How do you check database space?
What is my identity burn factor vulnerability right now in sybase?