what is the syntax of ALTER command?
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 load a large xml file?
How to get a list of all background sessions in the database?
while i take backup using ibm tsm the following errors occurred: rman-03009 ora-19513 ora-27206 ora-19502 ora-27030 ora-ora19511
How to write a left outer join with the where clause in oracle?
How to define an external table with a text file?
Explain the characteristics of oracle dba?
how do u setup a replication site?
From the following identify the non schema object: packages, triggers, public synonyms, tables and indexes.
what is the difference between sql& oracle?
How to find the date and time of last updated table?
What is a shared pool?
I have a database backup file in .db (ext) form how to conver it into .dmp (ext.) for oracle database