How to improve the performance of a pl/sq stored procedures or functions or triggers and packages ?
11 23573How 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 7685suppose 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 11470Post New IBM SQL PLSQL Interview Questions
How can we bind hibernate session factory to JNDI ?
Who is the mother of computer?
What are the points that should be considered by ports while binding?
How many tags are provided by jstl?
What is excel conditional formatting?
How does the length of a hash value affect security?
How do I stop solver?
What are the main features of requirejs?
What are the advantages of using third-party tools?
what is the circulate the diesel in DG in side pls tell parts name and picture with circulate the diesel
What is target namespace and taget prefix?
What are the useful commands of repl terminal?
Define the basic logical structure of a computer.
Hi I had missed my mark list (first year-apr2003)how i search in my old mark details in internet and which web site? pl inform me in full details..
Why does the system not calculate variance for the 500 kgs which has been delivered?