Answer / anil kumar jampana

declare
lowerl number:= 1;
upperl number:= 3;
num varchar2(10);
begin
for i in lowerl..upperl
loop
num:=num||to_char(lowerl);
if i=3 then upperl:=5;
end if;
end loop;
message(num);
end;
some changes in the programme.......
it will result 111

Answer / guest

result will be 111

Answer / kotesh

result is 11111

What is not in sql?

0 Answers  

---

Name three sql operations that perform a sort.

0 Answers  

---

What does select top 1 do in sql?

0 Answers  

---

Mention what does plv msg allows you to do?

0 Answers  

---

Sql technical questions

0 Answers  

---

How to pipe multiline string to isql?

0 Answers  

---

Define overloaded procedure?

0 Answers  

---

How to use sql*plus built-in timers?

0 Answers  

---

How to run sql commands in sql*plus?

0 Answers  

---

type type_name is table of varchar2(30) index by binary_integer for the above type you have to create a identifier... like identifier_name type_name; for the above type you can use the below methods..like first , last , prior, next , delege..etc...like this.. if you create a cursor...like cursor cursor_name is select * from scott.emp; is there any methods like above to use prior, fist , last , next , trim ,etc...

1 Answers   Satyam,

---

I have a CURSOR then why we need BULK COLLECT again?

1 Answers  

---

2. Select A.A from ( select 1 as from dual Union select 1 as from dual)A Full outer join ( select 1 B from dual Union select 2 B from dual)B On A.A=B.B

2 Answers   Fintellix,

---