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.
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 dynamic sql in pl sql?
how would you get the current date in mysql? : Sql dba
Is sqlite thread safe?
What is a table?
what does myisamchk do? : Sql dba
Differentiate pl/sql and sql?
explain the difference between bool, tinyint and bit. : Sql dba
What is the purpose of cursors in pl/sql?
Is stored procedure faster than query?
what are tables and fields? : Sql dba
Is sql developer case sensitive?
Can a table have no primary key?
Why do we create stored procedures & functions in pl/sql and how are they different?
What are three advantages to using sql?
how to create a new view in mysql? : Sql dba