what is the syntax of ALTER command?
- 8 Answers
- 12706 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 start a new transaction in oracle?
What are the numeric comparison operations?
What are various joins used while writing SUBQUERIES?
What are the execution control statements in oracle?
What is Data Dictionary Cache in Oracle?
Can I create users through internet explorer in oracle 10g?
What is pragma restrict_reference in oracle 9i?When we use this?Give me one realtime scenario?
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??
How to define an anonymous procedure without variables?
What is an external table?
Which Department has MOST NUMBER of employees?
8 Answers IBM, LeadSquared, Mastek,
What is sequence?
Oracle General 
