Answer / pravellika

create or replace procedure check1 (num number)
is
cursor c1(id number) is select b.a,b.city,b.code from (
select instr(id,code,1,1) as a,city,code from t1 )b
where b.a=1;
v_id number;
v_code NUMBER;
v_city VARCHAR2(100);
begin
open c1(num);
loop
fetch c1 into v_id,v_city,v_code;
exit when c1%notfound;
dbms_output.put_line(v_city||' '||v_code);
end loop;
close c1;
end;

Explain what is a database?

0 Answers  

---

What is a recursive join sql?

0 Answers  

---

How do sql databases work?

0 Answers  

---

table - new_no old_no 2345 1234 3456 2345 5678 4567 output sud be -new_no 1234 2345 3456 4567 5678

2 Answers  

---

What is Primary Key?

4 Answers   Ramco,

---

---

What are types of joins?

0 Answers  

---

what are different types of collation sensitivity? : Sql dba

0 Answers  

---

How do I sort a table in sql?

0 Answers  

---

How do you retrieve set of records from database server. {Set max records = 100 & use paging where pager page no or records = 10 & after displaying 100 records again connect to database retrieve next 100 }

2 Answers   DELL,

---

how to fetch alternate records from a table? : Sql dba

0 Answers  

---

Does truncate free space?

0 Answers  

---

What are sql commands?

0 Answers  

---