151: p_col_name ALL_TAB_COLUMNS.COLUMN_NAME%TYPE) IS
152: SELECT
153: COUNT(TAB.COLUMN_NAME)
154: FROM 155: ALL_TAB_COLUMNS TAB, USER_SYNONYMS SYN 156: WHERE
157: TAB.TABLE_NAME = UPPER(p_tbl_name) AND
158: SYN.TABLE_NAME = TAB.TABLE_NAME AND
159: SYN.TABLE_OWNER = TAB.OWNER AND