你测试一下看看

SELECT SCH.NAME AS SCH_NAME
      ,USR.NAME AS CREATE_USER
      ,SCH.INFO8
      ,UTL_RAW.CAST_TO_VARCHAR2(SCH.INFO8) AS SCH_DESC
  FROM SYSOBJECTS SCH
      ,SYSOBJECTS USR
 WHERE SCH.TYPE$ = 'SCH'
   AND USR.TYPE$ = 'UR'
   AND SCH.PID = USR.ID
   AND SCH.INFO8 IS NOT NULL