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 is clustered, non-clustured and unique index. How many indexes can be created on a table ?

3 Answers   TCS,

---

Which kind of parameters cannot have a default value in pl sql?

0 Answers  

---

how many tables will create when we create table, what are they? : Sql dba

0 Answers  

---

What is sql scripting?

0 Answers  

---

What is a self join ?

6 Answers   BirlaSoft,

---

Compare SQL and PL/SQL.

3 Answers  

---

What is a left join?

0 Answers  

---

How do I turn a list into a table?

0 Answers  

---

Differentiate between %type and %rowtype attribute in Oracle PL/AQL programming ?

7 Answers   PreVator,

---

Query for second maximum salary in each in each department

15 Answers   DST Global Solutions, TCS,

---

What are joins in sql?

0 Answers  

---

I am creating an index on Emp table Empno column,if u using this indexed column in ur SELECT stmt. where clause,then how do u know that yr index will be working or nor? Thanks Advance...

3 Answers  

---