Answer / rajesh venati

create or replace procedure pro(cname in varchar2)
is
n number:=0;
cursor ecur is select column_name from user_tab_columns;
begin
for i in ecur loop
if i.column_name=cname then
n:=n+1;
end if;
end loop;
if n>=1 then
dbms_output.put_line('column matched');
else
dbms_output.put_line('column unmatched');
end if;
end;
-----------------------------------------------------
SQL> exec pro('EMPNO');
column matched

PL/SQL procedure successfully completed.

SQL> EXEC PRO('RAJESH');
column unmatched

PL/SQL procedure successfully completed.

SQL> EXEC PRO('DEPTNO');
column matched

PL/SQL procedure successfully completed.

SQL> EXEC PRO('HISAL');
column matched

PL/SQL procedure successfully completed.

What is the difference between partition and index?

0 Answers  

---

What is a data definition language?

0 Answers  

---

what are the join types in tsql? : Transact sql

0 Answers  

---

What is the purpose of the partition table?

0 Answers  

---

What is the difference between database trigger and stored procedure?

0 Answers  

---

Is microsoft sql free?

0 Answers  

---

What is rownum in sql?

0 Answers  

---

I have 2 table A and B. In A 1 lakh record is present. In b 20 thousand data is present. To get the unique data from table A and B which join we should prefer left inner join or right outer join. Please answer.

4 Answers   GE,

---

What is record type in pl sql?

0 Answers  

---

What are the most important ddl statements in sql?

0 Answers  

---

Why are aggregate functions called so?

0 Answers  

---

What are the basic sql commands?

0 Answers  

---