How to improve the performance of a pl/sq stored procedures or functions or triggers and packages ?
12 29626How 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 8986suppose 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 13968Post New IBM SQL PLSQL Interview Questions
What access modifiers can be used for methods?
What is array and string?
What is the most important, or helpful,project that you have contributed to?
Explain gastrulation? What stage follows gastrulation?
What is java web application?
What are cookies in your browser?
What is Tcp/ip Model?
Define the role of ieee in computer networking?
Can I have multiple main methods in the same class?
Difference between chatter api and connect api in salesforce?
Can any one tell me.......How the test engg's start testing in the compy environment.....real time tester PLSSSS help me i need in depth information regarding this...
What is a data directory?
What is the use of hql in hibernate?
Can you get values from two different sources as a single input into parameter?
Why singleton is sealed?