Interested to Buy Any Domain ? << Click Here >> for more details...
what is the syntax of ALTER command?
- 8 Answers
- 14052 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 write an inner join with the where clause in oracle?
Can a property clause itself be based on a property clause ?
How do I start tns listener?
What is a nvl function?
How can you tell how much space is left on a given file system and how much space each of the file systems subdirectories take-up?
Difference between NO DATA FOUND and %NOTFOUND?
What happens to the current transaction if the session is killed?
What is meant by an index?
From the following identify the non schema object: packages, triggers, public synonyms, tables and indexes.
How to store pictures on to the database?
It's Urgent? How to IMPORT .xls & .txt file into ORACLE?
What is oracle server autotrace in oracle?
Oracle General 
