DBA Data[Home] [Help]

APPS.CS_KB_CONC_PROG_PKG dependencies on DBA_INDEXES

Line 797: SELECT COUNT(*) FROM dba_indexes

793: IS
794: drop_index VARCHAR2(100) := NULL;
795:
796: CURSOR get_index_cursor(p_index_name VARCHAR2, p_owner VARCHAR2) IS
797: SELECT COUNT(*) FROM dba_indexes
798: WHERE index_name = UPPER(p_index_name)
799: AND owner= UPPER(p_owner);
800:
801: l_total NUMBER := 0;