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 can I improve throughput in sybase?
Can I partition any table in sybase ?
State some of the products of sybase?
what is the difference between an ltm and a repagent in sybase?
What command helps you to know the process running on this port, but only su can run this command?
How does partition assignment relate to transactions in sybase?
What is my identity burn factor vulnerability right now in sybase?
List different types of sybase index.
How would you lock a table in sybase?
How do check the current running processes?
Differentiate between db-lib and ct-lib?
How can set the multipal database ?
How do I configure the burn factor in sybase?
Explain procedure cache?
Explain update statistics.