| how to built a dynamic sql [message #202492] |
Fri, 10 November 2006 00:54  |
sudharshan
Messages: 48
Registered: November 2006
|
Member |
|
|
i have a table with say - rule_component
which has two columns
1.db_table
2.from_clause
The two columns contains tables for example
db_table
------------
emp
dept
bonus
emp
def
from_clause
----------------
emp,dept,bonus,dept,emp,abc
My requirement
i want to find the duplicate tables in both the from_clause and db_table column
and populate in my from clause which are unique to both the columns
say example
select ......
from emp,dept,bonus,abc,def
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
