Answer Posted / 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 |
Post New Answer View All Answers
How many types of cluster table in Oracle?
What is the difference between post-database commit and post-form commit?
How index is implemented in oracle database?
What are the advantages of oracle 12c?
How to insert a record into a table?
How can you merge two tables in oracle?
What is literal?
Briefly explain what is literal? Give an example where it can be used?
Explain the types of exception?
Explain enable novalidate constraint.
What are the differences between date and timestamp in oracle?
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.
Typically, where is the conventional directory structure chosen for Oracle binaries to reside?
Explain the blob datatype?
I have some query regarding Report generation from Oracle Apps "PO module". I have to generate a report where table columns are as below: Vendor_name Invoice No PO Number Item_Quantity Value of Goods Date of Shipping Name_of_the_transport Date_of_receipt_issued. Now my questions is :from which table/column I can get the information of "Name_of_the_transport" column. Thanks in advance.