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 14408declare 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 8933#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 15926Post New Oracle Interview Questions
What is the difference between DECISION COVERAGE(DC) and MODIFIED CONDITION/DECISION COVERAGE(MCDC)?
There are 100 datafiles, numbered from 1 to 100. File number 10 is deleted and it has 500 MB of data. The database is working in archive log mode. How can be the database recovered ? While doing recovery the archive logs applied are from nos 1 to 100, but 50 gets corrupted. What do we do? Can we proceed further? If so how?
Explain different functions of internal audit?
What is seismic tomography?
How do I do a lookup table in excel?
WHAT IS THE PROFILE OF FINANCE EXECUTIVE IN TEXTILE INDUSTRY
What are the Limitations/Disadvantages of Rational Function Test?
Hi any one can help in preparing for BHEL ET exam in mechanical stream? I like to know the the question paper pattern fro the same. regards, Jose 9841327666 josevinoth@yahoo.com
If i have a dataset queried from Sql and I would like to insert the dataset into a specific node in an xml document how do I do this
Explain about getters and setters in php?
What are the differences between Tableau desktop and Tableau Server?
Single sign on functionality
Draw the flow of F.O. diagram from service tank to Main Engine?
Can you briefly explain the apache mahout?
What do you mean by java swing?