set echo off
set feedback off
set linesize 512

prompt ------------------------------------
prompt - Liste des types objet de la base -
prompt ------------------------------------

break on OWNER on TYPE_NAME

SELECT
   OWNER, 
   TYPE_NAME, 
   ATTR_NAME, 
   ATTR_NO, 
   ATTR_TYPE_NAME, 
   LENGTH,
   PRECISION, 
   SCALE
FROM 
   DBA_TYPE_ATTRS
WHERE 
   OWNER NOT IN ('SYS','SYSTEM','OUTLN','DBSNMP')
ORDER BY 
   OWNER, 
   TYPE_NAME, 
   ATTR_NO;
