How to improve the performance of a pl/sq stored procedures or functions or triggers and packages ?
12 28848How 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 8744suppose 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 13514Post New IBM SQL PLSQL Interview Questions
What are the core components of angular 2?
Describe cloud computing as concisely and simply as possible in layman language?
What are the core wpf assemblies?
What are the favorable conditions for formation of Anions?
How can you prevent overfitting in neural networks?
Suppose in the list applet field we have 10 records but I have to display only 2 records in list applet,what is the process should I follow?
What is jasper in tomcat?
Who developed d3.js?
Suppose to top five gainers on BSE same company can loser on NSE?
what is the function that is used to identify how many characters are there in a string?
Explain the use of each function in jquery?
How to increase the maximum execution time of a script in php?
How to execute function in stored procedure sql server?
What is the 'storage location rule'?
How do you take input in python?