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 14491declare 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 8991#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 16017Post New Oracle Interview Questions
What is devaluation and depreciation of currency?
What is drupal behaviors?
Difference interview organization owned entities vs user owned entities.
How does the elevation and air pressure affect the boiling point of water?
What are the main components in .net?
How do I create a hyperlink?
What is the difference between odbc and drs stage?
What is the disadventage of gland earthing(power cable) if any. ?
Explain what copy control is and when copy control transition can be done? In what manner copy control transition can be done?
Explain how are you going to remove duplicates from the file that is being read?
Explain the process of wep?
What is a shell made of?
What do you know about aidl?
How would you create a report using the report tool and report wizard?
Can treeset have duplicates?