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 14100declare 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 8771#include
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 15596Post New Oracle Interview Questions
How can multiple threads be controlled simultaneously?
Mention decorative design.
Hi Everyone... Under the Logical files, when am working on multiple rec format logical file, I have joined two pf's using the multiple record format logical file concept, but when i run queried the LF only the first mentioned pf records are reflecting and I am not able to see any of the field records specified under the second pf. Kindly let me know whats the reason behind this. Below is the str of LF., R rec PFILE(LOGICAA) CUSTNO CUSTNAME BILL K CUSTNO R rec1 PFILE(LOGICAA1) CUSTNO ADD K CUSTNO .....
Explain about contracts?
What is sum range in excel?
Excel sheet having some datas and some datas present in the application (in table). How will you compare these two datas? Write code to fetch datas from Excel sheet.
Can we hide tab in ms dynamic crm form using javascript? How?
What is distributed testing?
What is the requirement of thread in java?
Google analytics can help you learn more about the behavior of your client's customers. What is the reason?
i need modal Q. paper of junior enjineer for 1/2009 rrb ajmer exam cat no. 11 jell electrical thenkyou
What are industrial robots?
What are the causes of main engine Turbo Charger blower side dirty?
What things make you angry? How do you handle yourself in such a situation?
How would you define the exponents for a type âfâ field?