How to improve the performance of a pl/sq stored procedures or functions or triggers and packages ?
12 29627How 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 8988suppose 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 13968Post New IBM SQL PLSQL Interview Questions
What is a structure consisting of 2 or 3 tissues called as?
What is difference between path and classpath variables?
what is regions and endpoints in aws?
Which automation tools can be used for post-launch validation with continuous integration?
What is Sqoop Validation?
How do I add rows to a table in word?
Do I need a host for wordpress?
What does meta mean slang?
How do I get deterministic finalization in c#?
What are tablesets and setids in peoplesoft hrms?
Explain some reason to avoid the development of multi-threaded corba application?
Write a code snippet to launch firefox browser in webdriver.
How to stop database server in postgresql?
Describe the unusual stamens in many members of the Ericaceae. What two corolla shapes are typical of the family?
What does this () mean in java?