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

Explain what are the different type of segments?

1003


Can we write insert statement in function in oracle?

1156


State the various uses of dbcc command?

1110


Explain the truncate in oracle?

1013


How to drop an index in oracle?

1120


How to use subqueries with the in operator using oracle?

1139


Other than making use of the statspack utility, what would you check when you are monitoring or running a health check on an Oracle 8i or 9i database?

2038


How to fetch the row which has the max value for a column?

1046


How are extents allocated to a segment?

1182


How to recover a dropped table in oracle?

1095


How to assign data of the deleted row to variables?

1117


What privilege is needed for a user to query tables in another schema?

1033


How to convert characters to times in oracle?

1070


How to get a list of all user accounts in the database?

1131


How to select some columns from a table in oracle?

1175