Interested to Buy Any Domain ? << Click Here >> for more details...
ex: take one schema in that t1,t2,.....tn tables and you
don't no the table name also.
write a procedure if enter columns name then display the
maching columns .otherwise display the unmatch columns.
- 1 Answers
- 5062 Views
- Zensar, I also Faced
- E-Mail Answers
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.
| Is This Answer Correct ? | 6 Yes | 1 No |
Post New Answer View All Answers
What is rank function in sql?
How do I view tables in sql developer?
what is denormalization. : Sql dba
What is write ahead logging in sql server?
What are its different types of dbms?
Can we enter data in a table in design view?
Does view store data in sql?
How do I quit sql?
Is vs as in pl sql?
What are the types of variable use in pl sql?
What is sql engine in oracle?
How do I view output in sql developer?
What is a primary key sql?
What is the primary key?
Is sql easier than java?
