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...

what is the syntax of ALTER command?

Answer Posted / rajini

alter table tablename add(colname datatype,colname1
datatype...);
alter table tablename modify(colname datatype,colname1
datatype..);

Is This Answer Correct ?    9 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What are the different types of database objects?

1062


There are n numbers of flatfile of exactly same format are placed in a folder.Can we load these flatfile's data one by one to a single relational table by a single session??

2027


How to apply filtering criteria at group level in oracle?

1043


How many types of tables supported by oracle?

1077


What is the order of defining local variables and sub procedures/functions?

1061


What is different types of joins?

1022


How to define and use table alias names in oracle?

943


What is the parameter mode that can be passed to a procedure?

1048


What is system global area (sga) in oracle?

992


How to use group functions in the select clause using oracle?

1073


Explain the use of analyse option in exp command.

1128


State the various uses of dbcc command?

1060


Explain the truncate in oracle?

967


What are a query and state the different types of queries and their uses?

1016


How will you differentiate between varchar & varchar2?

1044