How to improve the performance of a pl/sq stored procedures or functions or triggers and packages ?
12 27119How 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 8233suppose 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 12646Post New IBM SQL PLSQL Interview Questions
How to install python and prepare environment?
Explain microstrategy logical primary keys?
What is differences in swift 1.x, 2.x, 3.x, 4.x?
Are you involved in writing the inferential analysis plan? Tables specfications?
i installed 100kva ups. what KVA genset they should provid in input side? plz any update formula or ans with reason.
how can you record information about current session?
What are the popular libraries used for flux?
How to set http request header in angular 4 and angular 2?
Can you explain how to enable and disable connection pooling?
How do you approach the diagnosis and counseling of patients with genetic hematologic disorders such as thalassemia or hemoglobinopathies?
How to use built-in messaging within the application?
What is the definition of crm? : salesforce crm
what about the power of wattmeter at starting and loding?
What is titration?
How can we find database related issues?