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 14134declare 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 8791Given 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 15634Post New Oracle SQL PLSQL Interview Questions
Define groupings for the public holiday calendar?
Why do you want to work for Microsoft?
Explain difference between machine config vs. Web config? : .NET Architecture
where to do the user related (personal) settings?
How to load excel data sheet to oracle database
Differentiate database index and match code.
What are various standard exceptions that salesforce throws?
What is mean tnq
How many rows and columns are in a chess board?
What are the most important things to learn in excel?
Which reactor has no moderator ?
Use of an integrity constraint is better to validate data. Explain
How forward () method is different from send redirect () method?
How important is the spring bean configuration file?
Tell me what do you understand by a view? What does the with check option clause for a view do?