How to improve the performance of a pl/sq stored procedures or functions or triggers and packages ?
12 23955How 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 7761suppose 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 11600Post New IBM SQL PLSQL Interview Questions
What is the function of NodeManager?
What is a meant by medium object mapping?
Explain the use of extension manager in joomla.
What protocols fall under the application layer of the tcp/ip stack?
How do you know if two cells match in excel?
plz send me sylyabus model quetion paper for drug inspector exam
What is kentchin?
Can we override interface methods in c#?
What are rows and columns in ms word?
What do you understand by numeric promotion?
How to create cascading filters without a context filter?
What is ctrl d in windows?
Do you always need a default constructor?
How to install laravel?
What is global file precedence in Splunk?