How to improve the performance of a pl/sq stored procedures or functions or triggers and packages ?
12 29217How many database objects (trigger, packages, sequence etc) uses a particular field in a given table. For ex: I want to know how many database object uses the ATTRIBUTE1 in the PO_VENDORS table. What query will give me the result showing the database object name(package, trigger etc), field_name used (in this case ATTRIBUTE1) and table_name (in this case PO_VENDORS).
2 8866suppose I have two table one Emp and other is dpt. Emp table has a field ,dept id,name ,sal and dpt table has a field dept id,dept name. Now I want to find out the emplyee list whose sal is between 2000-3000 from dept x.
7 13743Post New IBM SQL PLSQL Interview Questions
Should patient use mouthwash?
how JobTracker schedules a task ?
Why is there a need for broadcast variables when working with Apache Spark?
What is sandbox solution?
Questions on the projects listed on the Resume.
Explain the main features of sap db?
Genetically what are the two types of twins that can be generated?
How do you autosum in word?
Will an in place upgrade from exchange 2000 remove the m: drive?
How to give face effect in jquery?
Estimate the storage space required if a color image of 1024*1024 resolution needs to be digitized and image represedted in binary form
Who invented turbo c++?
Your team is constantly failing to meet commitments, and its performance velocity is volatile. What might the possible reasons be?
Why do we need linked lists?
Explain about the syntax rules in SOAP?