How to improve the performance of a pl/sq stored procedures or functions or triggers and packages ?
12 29248How 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 8879suppose 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 13769Post New IBM SQL PLSQL Interview Questions
How to handle non-transacted sessions with respect to jms?
How do you read parameters passed in the web dynpro url?
What is the diffrence between digital signal processing and discrete signal processing?
i have received my call caler till now what should i do
What are the tools used in sap-crm?
what is advantages and disadvantages of vlan?
Why need 3phase machine double earthing?
Where do you start the configuration in hcm module?
What is server side session?
What is foreign key in hibernate?
What is the purpose of @before?
What are the keyboard shortcuts in microsoft word?
in gas chromatography what is the difference between gas flow rate and average linear velocity ?
What are the mrp procedures in sap simple logistics?
Why is python weakly typed?