Write a query to get 2nd maximum salary in an employee table ?68 72544
What is an index and types of indexes. How many number of indexes can be used per table ?12 67920
What is a constraint. Types of constraints ?5 19127
What is a trigger ?10 11974
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 10778
will function return more than one value how9 14723
what is purge command explain about oracle performance tuning2 19369
Give an example of any procedure.5 10507
How will we see framework of a table?2 7224
When we give SELECT * FROM EMP; How does oracle respond?24 33669
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 5549
SQL Tuning, Oracle Server 10g: Why is the following hint invalid? SELECT /*+ first_rows parallel(table_name,paral_number)*/1 6415
What is different between union and minus?7 15079
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 8456
What is the relation b/w view and trigger3 8020
I have 2+ years of fake experience,actually i could not answer for project questions..?how can i answer please suggest me..?
What is datapool cursor?
WHAT IS MEANT BY CST? DO THE SUPPLIER CLAIM CST 2% FROM THE PURCHASER? WHAT ARE ALL THE RULES TO BE FOLLOW WHILE THE BUYER PURCHASE A 'C'FORM FROM THE CTO?
In case of new admission of partner what will be the adjustment for the sharing ratios
As jobs become more team-oriented, assessment centers will be used more often for non-management jobs. Do you agree or diagree?
for a 400kv t/m line with 10 ampere current will corona occur?
design a or gate using transister
using gradient pressure in gas chromatography are not ?using gradient pressure why
how we could adj. the entries of prop. & firm in merging time
What is Morphological gradient?
Why is Client side image is preferred over server side image?
please tell me what is graphics card ,version , type slot
what do you mean byrecoupment of shortworkings in royalty accounts
What are different ways to invoke a directive?
anyone send me aptitude and technical placement paper of Hewitt