Interview Questions  

Go Back   Interview Questions > Interview Questions & Answers > Information Technology > Databases > SQL PLSQL

SQL PLSQL SQL PLSQL Interview Questions, Learn by sharing SQL PLSQL Interview Questions asked in various Companies, Get Career advices, Interview Procedures from SQL PLSQL experts, Post asked SQL PLSQL Interview Questions and Answers.

   

Reply
 
LinkBack Thread Tools Display Modes
  #1 (permalink)  
Old 03-16-2008, 07:20 PM
Senior Member
 
Join Date: Mar 2008
Posts: 4,634
Default Declare lowerl number:= 1; upperl number

Declare 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 ?

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 ?

Reply With Quote
Reply

Tags
interview questions, sql plsql

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is On
Trackbacks are On
Pingbacks are On
Refbacks are On