Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- WITH
- index_cols AS (
- SELECT
- table_name,
- index_name,
- COLLECT(column_name) AS column_names
- FROM all_ind_columns
- WHERE table_name = '&table_name'
- GROUP BY
- table_name,
- index_name
- ),
- target_cols AS (
- SELECT '&column_name_1' AS col_name FROM dual
- UNION SELECT '&column_name_2' FROM dual
- )
- SELECT
- ic.*
- FROM index_cols ic
- WHERE
- (
- SELECT COUNT(*)
- FROM target_cols tc
- JOIN TABLE(ic.column_names) icc
- ON (tc.col_name = icc.COLUMN_VALUE)
- ) = (
- SELECT COUNT(*)
- FROM target_cols
- )
- ;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement