How to improve the performance of a pl/sq stored procedures or functions or triggers and packages ?
12 23829How 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 7750suppose 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 11565Post New IBM SQL PLSQL Interview Questions
what are the characteristics of Class Members in C++?
How do I generate a list of all .html files in a directory?
What is icm instruction?
What do you mean by platform independence? What is an interface?
Explain when can one deviate from any flight rules and regulations?
How do you measure the moment of inertia?
what is start center in maximo?
Define shrinking?
Give some examples of web applications that are used in our day to day life.
What is the difference between while and do while loop?
What is the difference between constructor injection and setter injection?
I am a newbie to QTP / Automation testing. I want to develop a script that creates a data file automatically with proper headings using VBScript in QTP.
Kindly specify the pic clause for the data type of length option field type of data fields?
What laptops come with word and excel?
Why to use char instead of varchar in the database?