How to improve the performance of a pl/sq stored procedures or functions or triggers and packages ?
12 29273How 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 8888suppose 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 13778Post New IBM SQL PLSQL Interview Questions
Meaning of ingrace protection for motor.for ex IPXY
What is the difference between physical file and logical file?
Differentiate constraint vs validation?
What do you know about uppercase filter and lowercase filter in angularjs?
Can you inherit from an abstract class java?
how do you debug and test your sas programs? : Sas programming
How can you use Perl warnings and what is the importance to use them?
In what scenarios jQuery can be used?
Does razor engine supports for tdd?
How would I sell something to some one over the phone? What is selling skill?
1)How much current can a 3-1/2 core 100 mm wire carry? 2)What are the special cables required for explosion proof wiring? 3)In case you do not have coal and salt for earthing, how can you achieve good temporary earthing? 4)One horse power single phase motor is more likely to get hot than a one horse power 3 phase motor. Is it true or false, if true why? 5)What are the different types of soft starters for large motors?please explain?
What are the different label of management that are found a large organization?
What is the full form of WindowsNT ?
define profiler???
What are the parameters of project system?