spool all_oco_policy_attr.rslt 

set linesize 130;
set pagesize 1000;
set long 50;
set echo on;

break on "OBJECT" on "Policy Name";

/* ****************************************************** */
/*                                                        */
/*  - will show all the POLICIE ATTR for a given database */
/*     - for use with CONTEXT CARTRIDGES                  */
/*                                                        */
/* ****************************************************** */

select  substr(OBJ_NAME,1,20)		"OBJECT",
   	  substr(to_char(OBJ_ID, '9,999'), 1,7)  "ID",
        substr(OAT_NAME,1,20)              	"Name",
        substr(OAT_DATATYPE,1,20)              	"DATATYPE",
        substr(OAT_DEFAULT_VAL,1,10)              	"DEFAULT_VAL",
	  substr(OAT_DESCRIPTION,1,40) 					"DESCRIPTION"
from ctxsys.ctx_object_attributes 
order by 1 asc, 2 asc;


set echo off;
spool off;
set long 80;
commit;









