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 can I improve throughput in sybase?

980


Can I partition any table in sybase ?

1052


State some of the products of sybase?

944


what is the difference between an ltm and a repagent in sybase?

963


What command helps you to know the process running on this port, but only su can run this command?

978


How does partition assignment relate to transactions in sybase?

938


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

937


List different types of sybase index.

912


How would you lock a table in sybase?

982


How do check the current running processes?

1012


Differentiate between db-lib and ct-lib?

1022


How can set the multipal database ?

2996


How do I configure the burn factor in sybase?

920


Explain procedure cache?

1004


Explain update statistics.

904