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 14591declare 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 9046#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 16139Post New Oracle Interview Questions
What are luminous irregular nebulae?
I need to get some data from data base and store this
(retrieved) data in a excel sheet using VB script in QTP9.0
I have created connection for data base
I have created as excels sheet by using
Set XL=CreateObject("Excel.Application")
XLworksheet.cells(1,1).value= rs.fields.item("<
as a general practice, it is recommended to have dbo be the owner of all database objects however, in your database you find number of tables owned by a user other than dbo, how could you fix this? : Sql server administration
Describe in brief sql server monitoring ways.
How do you delete undeletable files on a mac?
What do you mean by A.CC.?
Define commit log?
What is j2ee explain the component of j2ee application?
Do you know executive accounting?
What does the no logging option do? Why would we be careful of using it?
What is reactive power and where it is used.
What are write off entries to be passed say if im having payable of Rs. 400 standing in the balance sheet and I want to write it off...
What are the encryption functions available in PHP?
what is Batik Dyeing process?
How do you show trends in excel?