Write a query to get 2nd maximum salary in an employee table ?68 71627
What is an index and types of indexes. How many number of indexes can be used per table ?12 67174
What is a constraint. Types of constraints ?5 18868
What is a trigger ?10 11763
When we can declare a column as Unique and Not Null both at the same time. What is the use pf Primary Key then?2 10472
will function return more than one value how9 14365
what is purge command explain about oracle performance tuning2 19074
Give an example of any procedure.5 10315
How will we see framework of a table?2 7051
When we give SELECT * FROM EMP; How does oracle respond?24 33086
Dear All, Question for this Week Find out possible error(s) (either at compile time or at runtime) in the following PL/SQL block. State the reason(s) and correct the errors. Declare Cursor C1 is select ename, sal, comm from emp; Begin For i in C1 Loop If i.comm between 299 and 999 then Dbms_output.put_line(i.Ename || ‘ ** Good Commission’); Elsif i.comm > 999 then Dbms_output.put_line(i.Empno || ‘ ** Very Good Commission’); close C1; Else Dbms_output.put_line(i.Ename || ‘ ** ’ ||nvl(i.comm,‘O’)); End if; End Loop; End;7 5361
SQL Tuning, Oracle Server 10g: Why is the following hint invalid? SELECT /*+ first_rows parallel(table_name,paral_number)*/1 6289
What is different between union and minus?7 14705
wirte a query to filter improper date format follwing table? date 20-apr 22-may-2010 26-jun-2010 feb-2009 i want the output date 22-may-2010 26-jun-20105 8267
What is the relation b/w view and trigger3 7800
Why TCP/IP reference model is more popular than OSI model ?
how can i prepare for gate chemical in kolkata
How to calculate the Harmonics losses in terms of cost/unit.
Cognos Online Training will be provided. prior training with all real time aspects. Comprehensive training will be given in Datawarehousing concepts , cognos 8.4 and cognos 10 versions. Contact email@example.com
how to send multiple records which matches all the condition in the lookup transformation ? (if lookup matches the codition for duplicate values)
What is the thermal efficiency of a diesel engine?
what is through fault?
WHAT IS THE DIFFERENCE BETWEEN FOLLOWING... 1) WORKING CAPITAL MANAGEMENT AND CAPITAL BUDGETING 2) CURRENT ASSESTS AND FIXED ASSESTS PLZ GIVE ME ANS. IN THE FORM OF PRACTICAL ORIENTED AND ASPECTS OF BUSINESS
what will be the angular speed of a model of turbine whose dia is half of the real one and operating in 1/4 th of the head of the real turbine rotating in Nrpm.
4. State & explain the various financial & non- financial incentives to motivate the people in an organisation.
Hi I want to know how API gravity has been come up with in Oil Industry, especially figures in the following formula: API=(141.5/SG)-131.5
for what purpose the star point is done in ct
how to generate id in testdirector? a) Td id 1 b) td id 2 c) td id 3 d) td id 4 which is correct answer please any one of the tell me and mail me
Differentiate between Policy and Procedure.