Interested to Buy Any Domain ? << Click Here >> for more details...
what is the syntax of ALTER command?
- 8 Answers
- 13774 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 do I manually uninstall oracle client?
What is an oracle wallet?
what is the difference between rollback & commit? can a foreign key has null value?
How can I combine multiple rows into a comma-delimited list in oracle?
How do you handle duplicate records in a database?
How to grant create session privilege to a user in oracle?
Where do we use decode and case statements?
Tell me New Feature of Oracle 10g?
How to select the name of employee who is getting maximum sal with out using subquery
What is bulk load in oracle?
Please help me how to write a Query to change the primary key constraint from 1 attribute to another attribute in a table
Q) How to Find Max Date from each Group? (Asked in Infosys (INFI)Interview)
Oracle General 
