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;

What are different types of keys?

0 Answers  

---

If i can use sys.check_constraints to display my constraints from my database using sql server 2005, how can i display then if i am using sql server 2000????

0 Answers  

---

What are different types of statements supported by sql?

0 Answers  

---

Does access use sql?

0 Answers  

---

what is the differnce between procedure and function? in both dml operations can work and in procedure through out parameter you can return value ,then what is the differce?

3 Answers   3i Infotech,

---

How many types of indexes are there in sql?

0 Answers  

---

Which one of the following pairs of aggregate functions do you use with character fields? 1. COUNT(field) and MAX(field) 2. AVG(field) and COUNT(field) 3. MIN(field) and SUM(field) 4. AVG(field) and MAX(field) 5. COUNT(field) and SUM(field)

6 Answers   HCL,

---

Difference between IN and EXISTS

4 Answers   Nous, Polaris,

---

What are the types of triggers ?

26 Answers   Aspire, BirlaSoft, TCS,

---

What are the different tcl commands in sql?

0 Answers  

---

What is a trigger in pl/sql?

1 Answers  

---

Does execute immediate commit?

0 Answers  

---