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 12166declare 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 7774#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 13236Post New Oracle Interview Questions
Suppose I am not able to see any image on crystal report at run time. So how can I load any image which is saved in local disk so that it can be viewed at runtime in crystal reports?
What is a Foreign Key?
Mention the short-cut to edit variables in Scope?
How to calculate energy stored in an inductance?
What was is the primary usage of a 8085 microprocessor?
What is code blocks in views?
hi this is hema, r there any books in particular for the preparation of the APPSC-A.E.E(electrical), if so please mail me the names ... thank u .
Can you please explain creepage distance in detail, for a 6.6kV cable head what must the distance be and how do you determine it?
WHAT IS THE DEFINITION OF DEFAULT CUSTOMER IN AR?
What is the relation between how fast a leaf burns and the minerals or metallic elements contained in the plants?
If you start with 1 bacterium and double the number every 15 minutes, how many bacteria will you have at the end of 3 hours and 45 minutes?
Give an example of readable stream with flowing mode b?
Did you feel you progressed satisfactorily in your last job?
Discuss the use of Expression Editor in Talend
What is the function of character?