오라클 파라메터 조회

  SELECT NAME NAME_COL_PLUS_SHOW_PARAM,
         DECODE (TYPE,
                 1, 'boolean',
                 2, 'string',
                 3, 'integer',
                 4, 'file',
                 5, 'number',
                 6, 'big integer',
                 'unknown')
            TYPE,
         DISPLAY_VALUE VALUE_COL_PLUS_SHOW_PARAM
    FROM V$PARAMETER
--   WHERE UPPER (NAME) LIKE UPPER (:NMBIND_SHOW_OBJ)
where name like '%cursor%'
ORDER BY NAME_COL_PLUS_SHOW_PARAM, ROWNUM