What are the parameters that we can pass through a stored procedure?
No Answer is Posted For this Question
Be the First to Post Answer
Hello All, Could any one provide me FAQs/interview questions on oracle PL/SQL
Is there any way to find out when one specific table/view/M-view is used last time. i.e. when one specific object is used in any SELECT statement.
18. Display the clientno and total value for all orders placed by that client. Output the result in the following format: Client <clientno> has placed orders to the value of <total value>
An automatic job running via DBMS_JOB has failedKnowing only that its failed, how do you approach troubleshooting this issue?
What are the differences between char and varchar2 in oracle?
9. Display the client name and order date for all orders using the JOIN . . . USING method.
What is dynamic proxy?
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?
Is it possible to split the print reviewer into more than one region ?
What is an Index ? How it is implemented in Oracle Database ?
What privilege is needed for a user to delete rows from tables in another schema?
Shall I get Pro*C Compiler in Oracle-10g release ?