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
- 5125 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 difference between hql and sql?
What does fetching a cursor do?
What are the advantages of sql?
How exception is different from error?
What is the source code of a program?
What is before trigger?
What is difference between sql and excel?
What is a constraint?
What is pl sql and why it is used for?
What is microsoft t sql?
What are user defined functions?
What is the difference between truncate and drop statements?
What is the max nvarchar size?
Can we join tables without foreign key?
what is the difference difference between procedure and packages
