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 14430declare 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 8942Given 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 15955Post New Oracle SQL PLSQL Interview Questions
How to set fixed width in particular
What are transactions?
Explain the service container and its advantages.
Give us two of your biggest strengths and weaknesses.
What is sql*plus?
What is the process of changing the split size if there is limited storage space on Commodity Hardware?
What is the advantage of using asp.net routing?
Can java list contain duplicates?
what is current check gurd relay?
How do I debug a program in windows 10?
What is the sleeping time of python?
What is the difference between sonication and homozinization?
How the endl and setw manipulator works?
Why do we parse in c#?
What does mysql flush privileges do?