How to improve the performance of a pl/sq stored procedures or functions or triggers and packages ?
11 19151How 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 6366suppose 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 9022Post New IBM SQL PLSQL Interview Questions
What is 'gap insurance'?
What do you mean by ZNode?
Give me the code of in-order recursive and non-recursive.
Do you know headquarters of some Indian Government Banks?
What is the injector?
Ceiling Fan and Storage type water heater. Discuss
this is Ramu .i am working as sap sd end user.I am joined sap sd course but i am completed my graduation 2011. actually 2005 -2008 my education year. any plausibility to get good ob
Do inline functions improve performance?
how can I test reports in cagnos?
What is the importance of encryption on a network?
What are the adaptations of Halophites to salinity ?
How do you backup a database in mysql?
how to estimate man power for estimating the time required for completion of a project in terms of carpenters,barbenders,masons for block work ,masons for plasteing ,unskilled labour, painters, tiles masons,plumbers and electricians for medium and high rise constructions and independent villa projects.
What is time phased Planning?
What is the use of expression tree in c#?