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 14107declare 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 8777#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 15606Post New Oracle Interview Questions
What are the limitations oracle database 10g xe?
What is significance of jsf- spring integration?
password, is stored in as plain text. What can I do to protect my passwords?
How do we calculate?
What is php and how do you use it?
Note down the steps that are required to configure sap fiori transactional apps?
What is the difference between save() and persist() methods of session object?
You created a predictive model of a quantitative outcome variable using multiple regressions. What are the steps you would follow to validate the model?
What is default access modifier in Scala?Does Scala have 'public' keyword?
how to remove the instance?
1.why did you choose this career 2.what is pharmacists ideal job
Define the run-time architecture of Spark?
What is the use of scenario manager in excel?
What is the language from which Python has got its features or derived its features?
Which sorting algorithm is used in collections sort?