How to improve the performance of a pl/sq stored procedures or functions or triggers and packages ?
12 28895How 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 8759suppose 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 13536Post New IBM SQL PLSQL Interview Questions
What are the different software testing tools?
Which editor is used in Joomla?
How is random forests different from decision trees?
Does python have a built in function for string natural sort?
what is x'mer ,isolation x'mer & yltra-isolation x'mer?????
What is the syntax testing?
Explain an algorithm to find depth of a binary tree.
Explain types of comment in c# with examples
How do you delete multiple files at once?
How hive can improve performance with orc format tables?
Why we are using mvc instead of asp.net? : Asp.Net MVC
What are the advantages of thermal power plant?
Is mysql a postgresql?
Tell us do you know how to run reports? Can you customize reports? : insurance health
What is an api full form?