SELECT COUNT(DISTINCT i.INDEX_NAME)
FROM dba_ind_columns i
JOIN dba_tab_columns c
ON (c.TABLE_NAME = i.TABLE_NAME AND c.OWNER = i.TABLE_OWNER AND c.COLUMN_NAME = i.COLUMN_NAME)
WHERE
(UPPER(c.DATA_TYPE) LIKE 'VARCHAR%'
OR UPPER(c.DATA_TYPE) LIKE 'CHAR%')
Комментариев нет:
Отправить комментарий