How can we add a column to a table without altering the
same?
- 4 Answers
- 21281 Views
- BNP Paribas, I also Faced
- E-Mail Answers
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
There is no space in file system and you need to take a back up. What will you do?
How do you check database space?
How to connect sybase database from python?
What is the relationship between jdbc and sybase?
Explain defncopy and it's usage?
How do I open sybase control center?
What is asa ultralite in sybase?
Is sybase sql?
What is sybase used for?
Who owns sybase?
How to start and stop sybase database in linux sap?
How does partition assignment relate to transactions in sybase?
Explain coalesce.
Explain the advantages of data integration suite in sybase.
How to change varchar(m) to varchar(n) in sybase?
