Hi All,
I have three tables test1, test2 and test3
test1 columns are deptno,dname,loc
test2 columns are empno,deptno,etc
test3 columns are empno,deptno,etc
my requirement is based on column name get the table name
Here if i pass column name as deptno i will get all 3 tables
But i will pass combination like deptno,dname then i should get only one table
i tried below query but i am getting all the tables
select * from all_tab_columns where cname IN ('DEPTNO','DNAME')
Can any body please help me out?
Thanks,