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 / guest

alter table tablename add(col1 datatype,col2 datatype...);
alter table tablenamemodify(col1 datatype,col2 datatype..);

Is This Answer Correct ?    8 Yes 2 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Who developed oracle & when?

1005


What is a read write transaction in oracle?

1093


How are extents allocated to a segment?

1127


Her departmandaki isçilerden empno' su ikinci sirada olan isçilerin empno, deptno, hiredate, sira_no bigilerini döndüren sorguyu yaziniz?

1990


How many types of tables are there in oracle?

1061


Briefly explain what is literal? Give an example where it can be used?

1045


Why does for update in oracle 8 cause an ora-01002 error?

1003


What will be the syntax to find current date and time in format "yyyy-mm-dd"?

1011


how can db_files > maxdatafiles since db_files is for instance and the later is for database

2625


What is the quickest way to fetch the data from a table?

1058


What are the original export and import utilities?

1175


What is a lookup table in oracle?

973


Use of an integrity constraint is better to validate data. Explain

1043


What is a cursor and what are the steps need to be taken?

1203


Hi Masters, in Oracle Applications 11i, we hace 2 functions using the same form, i need to create 1 personalization, but that code must afect only one function.... how can i do that?

2222