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 14415declare 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 8939#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 15927Post New Oracle Interview Questions
What is jdbc architecture in java?
What is the use of jstl?
How many types of data validation methods are written on table level?
Explain artificial insemination?
Difference between drill down and drill through report.
Mention platforms which are used for large scale cloud computing?
Why are the employers not disclosing the results or the defects of the specific candidate soon after Interviewing process? Is There any complication which will arise in mentioning the details or to keep them confidential?
What is doctype good for?
How do I set the computer to use a single button on the taskbar in ms word?
how can i add properties in dynamic text fields using .js file?
What is a batch file used for?
What is the extension of c++?
How is a session stored and maintained in asp.net?
Explain syntax for dropping triggers?
What is the use of property-set Method?