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 the difference between truncate and drop statements? : Sql dba
what is oltp (online transaction processing)? : Sql dba
what is error ora-03113: end-of-file on communication channel?
Is truncate ddl or dml?
How does a covering index work?
What kind of join is join?
how would you write a query to select all teams that won either 2, 4, 6 or 8 games? : Sql dba
what is isam? : Sql dba
what is the command used to fetch first 5 characters of the string? : Sql dba
What is attribute indicator in pl sql?
What is a database? Explain
Does asenumerable execute the query?
Does execute immediate commit?
What is pl sql block structure?
Is sql pronounced sequel or sql?