How to improve the performance of a pl/sq stored procedures or functions or triggers and packages ?
12 28777How 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 8724suppose 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 13489Post New IBM SQL PLSQL Interview Questions
What are the disadvantages of spring framework?
What is servlet used for?
What type of memory is the stack?
What are the interferences in cdma?
Explain pipelining? : .NET Architecture
Classify the apple into fruits, roots, stem.
What is asynchrony in mq?
How spectral lines show discrete energy levels in an atom. : quantum physics
What causes a runtime error c++?
What is the shortcut to delete a blank page in word 2007?
Mention some of the validator tags used in JSF?
Test a function that reads a file into memory, say ReadFileToMemory( FILE * pFile, BYTE * pMem, DWORD numBytes)
What is difference between dao and service?
How to change window manager by editing your home directory?
What is flush programming?