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
How to force the intellij idea to reread/update all dependencies specified in the pom file?
What are the operators in sql?
What is the difference between drop table and truncate table?
Why mongodb is faster?
Which database the sqoop metastore runs on?
Explain what is assertion in jmeter? What are the types of assertion?
What html5 means?
How to make websphere auto-start when server reboot?
How to connect the remote desktop using QTP 9.2 explain the method or procedure?
What are the benefits of swing over awt?
So how do we refresh the application cache of the browser?
in OSD forms require to use gas chromatography?
How would you Create a Query Builder and Explain its uses ?
Why do we need annotations in spring?
Can I run any transact-sql command on a partitioned table in sybase?