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.

How do I filter in sql profiler?

0 Answers  

---

What are different types of triggers?

0 Answers  

---

Is t sql a programming language?

0 Answers  

---

Write a query to find the employees from EMP table those who have joined in Monday. (there is a column as hiredate which is a date column i.e values are like 03-DEC-81)

5 Answers  

---

How can i insert data inro a table with 3 columns using FORALL?

2 Answers   Oracle,

---

What is difference between primary and secondary key?

0 Answers  

---

Define a temp table?

0 Answers  

---

What is vector point function?

0 Answers  

---

Advantages and disadvantages of stored procedure?

0 Answers  

---

how will i became good database developer?

1 Answers  

---

if we give update table_name set column_name= default. what will happen?

4 Answers   iFlex,

---

How do you declare a variable in pl sql?

0 Answers  

---