Answer Posted / 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 |
Post New Answer View All Answers
Explain what are the different type of segments?
Can we write insert statement in function in oracle?
State the various uses of dbcc command?
Explain the truncate in oracle?
How to drop an index in oracle?
How to use subqueries with the in operator using oracle?
Other than making use of the statspack utility, what would you check when you are monitoring or running a health check on an Oracle 8i or 9i database?
How to fetch the row which has the max value for a column?
How are extents allocated to a segment?
How to recover a dropped table in oracle?
How to assign data of the deleted row to variables?
What privilege is needed for a user to query tables in another schema?
How to convert characters to times in oracle?
How to get a list of all user accounts in the database?
How to select some columns from a table in oracle?