Interested to Buy Any Domain ? << Click Here >> for more details...
what is the syntax of ALTER command?
- 8 Answers
- 13833 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / sridevi
alter table <table name> modify (columnname newdatatype
(size))
| Is This Answer Correct ? | 18 Yes | 4 No |
Answer / sridevi
alter table <tablename> add column(col.name(size))
| Is This Answer Correct ? | 17 Yes | 8 No |
Answer / 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 |
Answer / guest
alter table tablename add(col1 datatype,col2 datatype...);
alter table tablenamemodify(col1 datatype,col2 datatype..);
| Is This Answer Correct ? | 8 Yes | 2 No |
Answer / guest
alter table <table name> modify(column definition...);
alter table <table name> add(column definitions...);
| Is This Answer Correct ? | 7 Yes | 2 No |
Answer / suri
alter table tablename add(colname datatype,colname1
datatype...);
alter table tablename modify(colname datatype,colname1
datatype..);
| Is This Answer Correct ? | 2 Yes | 1 No |
Answer / sandeep
alter table <table_name> add column <Data type of the column>;
| Is This Answer Correct ? | 2 Yes | 3 No |
How to speed up webrick?
Can we save images in a database and if yes, how?
What is a server parameter file in oracle?
How to change user password in oracle?
HI ALL, CAN ANYONE TELL ME THE DIFFERENCES BETWEEN SQL CLUSTURS,MSQL CLUSTERS,ORACLE CLUSTERS.......THANKS IN ADVANCE
What are the predefined tablespaces in a database?
 How to use an oracle sequence generator in a mapping?
Difference between join and a subquery?
8 Answers Base Automation, NMDC,
What is an oracle recycle bin?
Explain mutating triggers.
How to find the date and time of last updated table?
what is analyze command ? what kind of statistics does it generate?
Oracle General 
