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 11295declare 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 7259Given 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 12084What action do you have to perform before retrieving data from the next result set of a stored procedure ?
1957What cursor type do you use to retrieve multiple recordsets?
Apollo, CTS, IonIdea, Microsoft, Oracle, TCS, Vmoksha, Wipro,
17 62262
What is a data manipulation language?
What is the difference between mdf and ndf files?
What is the difference between left and left outer join?
How can you tell the difference between an index and a view?
How do I view output in sql developer?
What is the full form of sql?
What is normalization in sql?
What is a mutating table and a constraining table?
What is sql query optimization?
Write the alter statement to enable all the triggers on the t.students table.
Show code of a cursor for loop.
What is Histogram?
What is Difference Between Unique and Primary Key Constraints?
How do I create a sql script?
What is the difference between sql and mysql?