Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

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


Please Help Members By Posting Answers For Below Questions

How would you fix a munged log in sybase ?

959


List different types of sybase index.

879


Is sybase open source?

877


A single operation is failing to escalate?

823


How to find the time taken for rollback of the processed?

968


Differentiate between db-lib and ct-lib?

969


How configure sybase odbc connection?

900


What do you mean by mainframe connect tool in sybase?

898


What is coalesce in sybase?

942


Why am I running out of locks on the replicate side in sybase ?

1017


What are table partitions? How is it different with ase 15.0 version?

881


Explain procedure cache and data cache in sybase.

898


Who owns sybase?

845


How do you check database space?

1011


What is my identity burn factor vulnerability right now in sybase?

894