How can we add a column to a table without altering the
same?

Answer Posted / devraj

In Oracle - create nother table with new column
2. insert complete data into this
3. drop orignal table
4. rename the created table to orignal table

Is This Answer Correct ?    12 Yes 26 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What will you do if a replication thread goes down?

741


Can I use a named pipe to bcp/dump data out or in in sybase?

765


How do I configure identities in sybase?

640


How to pad with leading zeros an int or smallint in sybase?

601


How do I connect to sybase?

654


Explain index covering?

633


what is update statistics in sybase?

818


How do check the current running processes?

707


How configure sybase odbc connection?

627


What are the operating systems in which sybase could take its presence?

653


Explain about sybase 365?

633


How to delete unix files which are more than 3 days old?

665


Explain data cache?

640


How do I find the oldest open transaction in sybase?

627


What is procedure cache and data cache in sybase?

617