What is correlated sub-query?7 33824
how instead of triger is helpful for mutating tables errors handlling ?2 6919
What are the advantages of the packages6 6530
what are the advantages of primary key over unique+notnull7 14397
how to retrieve the top 3 salaries of the table using rownum31 21651
what is the difference between union and union all14 32285
What is the difference between join and union.27 153743
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 8270
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 5212
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 8116
What cursor type do you use to retrieve multiple recordsets?17 49259
Two Methods of retrieving SQL?7 44827
How do you optimize SQL queries ?6 24613
Delete duplicate records in the emp table.6 9394
11KV AND 22KV NETWORK KW CAPACITY IN RING AND RADIAL?
how to store the vacuum in tank? its possible? what are the units for measure the vacuum ?
What is the Systematic Responsibility Site Engineer? Who are the above and under co-oridinating ? What is office & Site co-ordination of Site Engineer?
how we implement share object repository in QTP 9.0 without using quality Centre , Explaine in brief
sir,would you please send me the Hindustan petroleum corporation limited papers(HPCL).my e-mail ID is email@example.com
Is it required to lay GI wires along with GI/MS conduits from one point to another point though separate earthing cable is conncted from DB to Socket?
How to enhance the growth rate of E.coli in M9 media?
Why should you consider yourself fit to be hired by JSPL? (max 200 words)jindal steel & power ltd
Can I use distributon class/transmission class Lightning arresots for protecting the building? If not why please explain?
how can LED bulb indication work correctly without CT OR PT for 3 phase indication if one is cut then it will show the correct indication?
I recorded a Web App with a Oracle backend using QTP 9.5 and for some reason the scripts don't play back> What am I missing at this point. I recorded the same Apps under Sybase and they work great. This is Oracle 10g. Why won't my scripts play back.
please send me oracle pl/sql exp resume. and also faqs...
What is the difference between Maintenance Order and Production Order. the point is i want to know the affection of Movement type 261 thru maintenance order and Production order. if i change any settings for Maintenance order it will affect to production order process also for 261 movement type ?
How to Retrieve the line number that a memo's cursor is on?
what are the standard methods for HPLC?