What is correlated sub-query?7 32663
how instead of triger is helpful for mutating tables errors handlling ?2 6572
What are the advantages of the packages6 6157
what are the advantages of primary key over unique+notnull7 13538
how to retrieve the top 3 salaries of the table using rownum31 20280
what is the difference between union and union all14 30937
What is the difference between join and union.27 147120
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 7919
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 4952
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 7538
What cursor type do you use to retrieve multiple recordsets?17 46219
Two Methods of retrieving SQL?7 43135
How do you optimize SQL queries ?6 23285
there are 2 variables called x and y ,x contains 1,2 and y contains 3,4 we have to swap the values from x to y and y to x with out using dummy variables and it can be done only by using a single statement ? how?12 9781
What is the magnetic field (coil DC ) of Turbo Expander?
What do you know about the historical background of Development Financial Institutions (DFIs)?
What is the difference between specifying a constant variable like with constant keyword and #define it? i.e what is the difference between CONSTANT FLOAT A=1.25 and #define A 1.25
I am sathish , i want to test the Application of JIL.org ,Mobile Emulator ,by using QTP10.0. I am trying to do testing on that Application , but Child Objects are not identified by the QTP. Please can any one help me
I HAVE DONE B. SC . (BIO) AFTER THAT I HAVE DONE MBA HR AND NOW MANY INTERVIEWER ASK ME WHY I HAVE HONE MBA IN HR? PLZ ANSWER ME?
What is aggregate Liabilities ?
1.) How would you describe yourself?
how do u really know that paging to disk is happening while u are using a lookup transform?
Give the Core Architecture?
what is the critical defect in telecom domain?help me out from this prob its very urgent
write a report on 'house path management'.
I need to obtain the parent of an object programatically, so if I have: winButton("aButton") I need to obtain the parent part: window("Window1").Dialog("Dialog1") so I can programatically create a string of the full name of the object to call it with an execute statement in QTP I would like to use something like: part = "window(""Window1"")" part = "dialog(""Dialog1"")" so I can do: exeLine = part&"."&part&"."&"winButton(""aButton"")" Execute exeLine Apart from keeping a record of the window/dialog hierarchy is there a parent or path function/ command Thanks Adrian
What is alpha test in alumina powder?
What is the indication of leaking starting valve of an engine?
suppose we have 400 users in that 300 can able to connect to the Database and 100 cannot