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
What are the different types of database objects?
There are n numbers of flatfile of exactly same format are placed in a folder.Can we load these flatfile's data one by one to a single relational table by a single session??
How to apply filtering criteria at group level in oracle?
How many types of tables supported by oracle?
What is the order of defining local variables and sub procedures/functions?
What is different types of joins?
How to define and use table alias names in oracle?
What is the parameter mode that can be passed to a procedure?
What is system global area (sga) in oracle?
How to use group functions in the select clause using oracle?
Explain the use of analyse option in exp command.
State the various uses of dbcc command?
Explain the truncate in oracle?
What are a query and state the different types of queries and their uses?
How will you differentiate between varchar & varchar2?