How to improve the performance of a pl/sq stored procedures or functions or triggers and packages ?
12 23791How 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 7743suppose 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 11563Post New IBM SQL PLSQL Interview Questions
What is the principle of HIGH SPEED DIRECT DRIVE MOTOR ?
Give an example for pre testing and post testing ?
Write the total description of Ultra Commissioning.
What is the relation between reaction taking place in one of the several stages and the total amount of energy liberated in the reaction?
What happens if we put a key object in a hashmap which exists?
Where is outlook exe located?
What is the typical fauna of the tropical forests?
Differentiate between control keys pm02 and pm03.
What is a testing process / lifecycle?
2Create a program that accepts a number and output its equivalent in words (maximum input number is 3000). for example Enter a number: 1380 one thousand three hundred eighty
How do you align a table to the right (or left)?
Write a program that ask for user input from 5 to 9 then calculate the average
For my web Application I am recording website by WR. but the fuctions are displaying normal recorded fun. such as set_window...etc. eventhough i selected web add-in at start up WR. how to use web functions? such as web_link_click.... pls. guide
What is Lossless join property?
Is siri an artificial intelligence?