How to improve the performance of a pl/sq stored procedures or functions or triggers and packages ?
12 28874How 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 8748suppose 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 13522Post New IBM SQL PLSQL Interview Questions
How can you apply the same formatting to every sheet in a workbook in ms-excel?
How is a css executed in case of more than one conflicting rule?
1) can any one tell how dozer transmission system power terrain --track
What is nested interface?
What is the usage of iis?
Where is reference in word?
What is the vanishing gradient problem in deep learning?
What is a lease agreement? What are its contents?
what is blob?
Name the branch of chemistry that deals with the relationship between electricity and chemical reactions?
What is dynamic linking?
Explain what is sap?
What is configuration management in terms of infrastructure and mention a few popular tools used?
How DC earth leakage currents can be reduced ?
Please brief me about number of pole in alternator.In single phase alternator coils are connected in star or series. How to calculate frequency for the same.