Write a query to get 2nd maximum salary in an employee table ?68 81859
What is an index and types of indexes. How many number of indexes can be used per table ?12 72640
What is a constraint. Types of constraints ?5 20886
What is a trigger ?10 13926
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 12876
will function return more than one value how9 17148
what is purge command explain about oracle performance tuning2 21395
Give an example of any procedure.5 12030
How will we see framework of a table?2 8419
When we give SELECT * FROM EMP; How does oracle respond?24 39393
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 7210
SQL Tuning, Oracle Server 10g: Why is the following hint invalid? SELECT /*+ first_rows parallel(table_name,paral_number)*/1 7423
What is different between union and minus?7 17861
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 10098
What is the relation b/w view and trigger3 9975
you are recording on "WINDOW 1", say it has a link if you click on that, that leads you to "WINDOW 2". If you do any manipulations on "WINDOW 2" that are automatically updated in to "WINDOW 1". But "WINDOW 1" is currently invisible. But the updations in "WINDOW 1" must also be recorded as a script in QTP. The best Example is if you update your resume in JOB STREET portal it actually happens in other window, but the previous window is automatically updated. Now does QTP help you in this types of situations? Any body can answer this question. please..... Siva
What is dogpile mechanism? Explain.
I am going for an interview for back end and ui testing. Can smone tell me some important questions?
What is meant by MIME?
Which are commonly used php based cmss ?
What is microsoft visual c++ 2017 redistributable?
What is a bubble sort in java?
What is payroll driver
Can I work with several databases simultaneously? : sql server management studio
How to accelerate electron capture decay?
How many types of ngmodule?
What is the difference between microprocessor and DSP?
After removing a table from database, what other related objects have to be dropped explicitly?
How will you remove all leading and trailing whitespace in string in python?