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 14627declare 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 9059#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 16174Post New Oracle Interview Questions
What do you mean by summary index?
How will the Internet of Things (IoT) impact the sustainability of Environment or Business?
How do you create a cell graph in excel?
How many null values we can have in a unique key field in sql server?
what is the shortcut in MS Outlook 2013 to switch on to the next message?
What does the enableviewstatemac setting in an aspx page do?
what is the reason for spark appearing in mixer grinder
What is the function of the dd avgrec keyword in sms datasets?
What is context in core data ios?
Explain about thread and memory management process of SQL?
What is Mapper in Hadoop?
What is cd command in windows?
Show the declaration for a pointer to function returning long and taking an integer parameter.
Explain url helper? Can you list some commonly used url helpers in codeigniter?
What are user defined functions?