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 12082declare 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 7724Given 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 13129What action do you have to perform before retrieving data from the next result set of a stored procedure ?
2078What cursor type do you use to retrieve multiple recordsets?
Apollo, CTS, IonIdea, Microsoft, Oracle, TCS, Vmoksha, Wipro,
17 64575
What is difference between table and view?
How to get each name only once from an employee table?
What will you get by the cursor attribute sql%notfound?
How do I find sql profiler?
What is a sql instance vs database?
How do I view an execution plan in sql?
What are pl/sql cursor exceptions?
how many ways to get the current time? : Sql dba
What are different types of sql?
What is an intersect?
What is procedure explain with program?
What is parameter substitution in sql?
What is implicit cursor in pl sql?
Explain the difference between rename and alias?
What is a mutating table and a constraining table?