Answer Posted / 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.

Explain what is a subquery ?

1122

---

What is int identity in sql?

1059

---

How to install oracle sql developer?

984

---

What is the use of index in sql?

958

---

What type of join is sql join?

921

---

What is a sql statement?

900

---

What is a database trigger?

1017

---

Any attempt to navigate programmatically to disabled form in a call_form stack is allowed?

1040

---

What are the advantages of pl sql over sql?

962

---

What is program debugging?

1129

---

Can we have two clustered index on a table?

966

---

Can one improve the performance of sql*loader? : aql loader

981

---

Does sql*plus also have a pl/sql engine?

1037

---

Hi am new to PLSQL & facing problems in writing code like in SP, Functions, so any one having some SP coding with in depth explanation please share with me my Email ID suvarnaatsuvarna@rediffmail.com Or taking tanning on this please do contact me

1958

---

How do I view tables in mysql?

915

---