Hello All,
Could any one provide me FAQs/interview questions on
oracle PL/SQL
Answer / krishna
Plese see thin link: http://www.orafaq.com/wiki/PL/SQL_FAQ
| Is This Answer Correct ? | 1 Yes | 0 No |
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.
Design database draw er diagram for a certain scenario ?
0 Answers Keane India Ltd, TATA,
What is DTS and purpose of DTS ?
How to execute a stored procedure in oracle?
Can we call procedure inside function in oracle?
I have one table :EID,Depid,ename,sal I want to have max(sal) in each department.
5 Answers Microsoft, Oracle, TCS,
Can a property clause itself be based on a property clause ?
What is a subquery in oracle?
what happened to the global index when I truncate the data in one of the partition?
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>
How to set up autotrace for a user account?
19. Display all clients whose name begins with the letter J or contains the letter M anywhere or contains E as the third letter.