What is correlated sub-query?7 36702
how instead of triger is helpful for mutating tables errors handlling ?2 8149
What are the advantages of the packages6 8022
what are the advantages of primary key over unique+notnull7 17190
how to retrieve the top 3 salaries of the table using rownum31 25863
what is the difference between union and union all14 36754
What is the difference between join and union.27 163769
declare l1 number := null; l2 number :=null; begin if l1=l2 then message('equal'); else if l1<>l2 then message('not equal'); else message('else'); end if; end if; end; What will be the output ?7 9882
declare lowerl number:= 1; upperl number:= 3; num varchar2(10); begin for i into lowerl..upperl loop num:=num||to_char(lowerl); if i=3 then upperl:=5; end loop; message(num); What will be the output ?3 6357
Given two tables Student(SID, Name, Course) and Level(SID, level) write the SQL statement to get the name and SID of the student who are taking course = 3 and at freshman level.9 10219
What cursor type do you use to retrieve multiple recordsets?17 56295
Two Methods of retrieving SQL?7 49226
How do you optimize SQL queries ?6 28028
How well can multiple sessions access the same data simultaneously ?1 1804
Delete duplicate records in the emp table.6 10821
insted of bentonite we can use any alternate material in piling ?
How to make qtp understand the difference amongst the same type of objects .suppose there are 5 check boxes in a page and I have to choose the 2nd one, how to do that through script?
Discuss the otto cycle with diagram.
Which is better cakephp or laravel?
On which platform j2ee is based?
How errors in talend are handled?
What are mapplets? How is it different from a Reusable Transformation?
What is the relationship between a queue and its underlying array?
what is the sludge current
What is defined isalpha() in python?
What is the element in third series the element with maximum oxidation state?
HOW CAN I OPEN A CC A/C ? WHAT ARE THE MINIMUM REQUERMENT TO OPEN A CC A/C ? WHAT ARE THE FACILITY OF A CC A/C IN THE BUSINESS FIELD ? WHAT ARE THE BANK CHARGES AND INTEREST IN CC A/C ?
What is nsmutablearray?
What is backing bean?
How do I compare files in notepad ++?