1. Display the post code and the purchase order number for
each purchase order. Sort the output set by postcode.
Explain the difference between a procedure and a function? What do you understand by those terms?
Hi how Can I Add A Foreign key that references a table that has composit primary key ? example i had costumer table that has C_Id and SSN Both as PK and another table has C_Id that must refernece C_Id in Customers i done the usual way and got oracle error message about uniqeness any ideas plz
Explain an exception?
Explain the use of indexes option in exp command.
can you write commit in triggers?
What is Read-Only Transaction ?
How to delete a column in an existing table in oracle?
what is the difference between simple view and complex view?
1.how to extract the second highest salary from emp table having sal as a column which contains the salary of all employee of an organisation.
Give the various rollback segment states.
What are the set operators union, union all, minus & intersect meant to do?
what are the disadvantages of hierarchial database over RDBMS?