How to improve the performance of a pl/sq stored procedures or functions or triggers and packages ?
12 29246How 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 13767Post New IBM SQL PLSQL Interview Questions
Why is Kotlin preferred over Java? Important benefits of kotlin?
Difference between @staticmethod and @classmethod in python?
What is tuple?
What is the homepage in joomla?
Can min or max be used with alphanumeric data?
List some applications of tree-data structure?
Is c++ similar to swift?
What is heap sort in c++?
What is the importance of Global.asax in ASP.NET?
What is example of database?
What are the operators available in ruby?
describe different skills required for a manager and pesponsibilities of a professional manager.
What is spooldir flume?
What is standard of DCS panel design?and what is step of DCS panel design?wiring and type of connector(screw or DB connector)
What is the purpose of global-forwards tag in struct-config.xml?