/* ************************************************ */
/*                                                  */
/* format the report:                               */
/*        SRL CASE ATTRIBUTE                        */
/*                                                  */
/* name:    @c:\oracle\sql\cdi_att.sql              */
/* date:    12-MAY-95                               */
/* creator: Rick Kupcunas (Oracle)                  */
/*                                                  */
/* ************************************************ */

set feedback  off
set wrap      on
set pagesize  60
set space     1 
set linesize  80
set newpage   0
set trimout   on
set verify    on
set underline =
set echo      off
set termout   off

spool cdiatt.lst

ttitle left "PAGE:" sql.pno format 999 -
  center 'SRL CASE ATTRIBUTE Report ' right CWS_DATE skip 2
  break on entity skip 2
 column ENTITY             format a20    heading 'SRL ENTITY'
 column NAME               format a30    heading 'ATTRIBUTE NAME'
 column FORMAT             format a9     heading 'FORMAT' 
 column LENGTH             format 9999   heading 'LNTH'
 column PRECISION          format a4     heading 'PRCN'
 column OPTIONAL           format a6     heading 'OPTNAL'

select entity, name, format, length, precision, optional
from cdi_attributes
where SRL CASE ATTRIBUTE = 'SRL'
order by entity, name;

spool off
