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 is a nested table?
What are the major difference between truncate and delete?
I just want to maintain data like an employee can belongs to 3 or more departments . We can resolve this by using composite key but it avoids normalization rules. So Can anyone tell me how can I maintain data.
What do you mean by merge in oracle and how can we merge two tables?
How does the on-delete-cascade statement work?
State the various uses of dbcc command?
Explain joins in oracle?
Explain the importance of .pll extension in oracle?
Differentiate between post-database commit and post-form commit?
How to create an oracle database?
6. Display the client name and order date for all orders using the traditional method.
In XIR2 if we lost the administration password .How can we regain the password?thanks in advance.
What is a view and how is it different from a table?
How to select some columns from a table in oracle?
What happens to indexes if you drop a table?