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 check the long running transaction?
How do I move tempdb off of the master device?
You need to multiply all values of a single column. How would you do that?
Can I use a named pipe to bcp/dump data out or in in sybase?
Explain tds (tabular data streams).
Compare in and exists?
Is there any advantage of last_name varchar(50) over this last_name varchar(255)?
Alternative to row at a time processing in sybase?
Which version of open client works with which ase in sybase?
How do I open a sybase database?
What is open server in sybase?
Explain procedure cache?
How to save space when inserting rows monotonically?
How do I set ts role in order to run certain dbccs?
What is server replication?