Interested to Buy Any Domain ? << Click Here >> for more details...
what is the syntax of ALTER command?
- 8 Answers
- 14146 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 |
If a table column has is UNIQUE and has NOT NULL, is it equivalent to a PRIMARY KEY column?
What is a database table in oracle?
What are the attributes of cursor?
Why packages are used in oracle?
What is an Oracle Instance?
How to create a testing table in oracle?
How to display employee records who gets more salary than the average salary in the department?
is database gud carrier option??
How to get last row id?
How to write date and time literals in oracle?
How to Remove the 3rd highest salary person record from table?
Whether any commands are used for months calculation? If so, what are they?
Oracle General 
