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 |
What is oracle latest version?
What is autonomous transaction?
How to use existing values in update statements using oracle?
Explain an integrity constrains?
Can we write dml statement in function in oracle?
A and B are tables. x is a column. Then What is difference between A.x = B.x(+) and A.x = B.x ?
Ho to insert no. of records at a time..i mean i want to insert 100 records at a time into a table
What privilege is needed for a user to create tables in oracle?
How to retrieve data from an cursor to a record?
you are sorting a table using "order by"(descending) clause of a column which contains a null value...whether that row containing null value will come first or last in the output??
Respected sir, Please send me technical questions related to oracle apps..
What is cluster Key ?