spool all_oco_stop_list.rslt 

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

break on "PREFERENCE" on "Policy Name";

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

select  substr(PRE_NAME,1,20)			"PREFERENCE",
   	  substr(to_char(ATT_SEQ, '9,999'), 1,7)  "SEQ",
        substr(ATT_NAME,1,20)              	"Name",
        substr(ATT_VALUE,1,20)              	"Value",
        substr(ATT_DESC,1,10)              	"Description",
	  substr(ATT_TYPE,1,40) 					"Type"
from ctxsys.ctx_preference_attributes 
where PRE_NAME = 'DEFAULT_STOPLIST' or
PRE_NAME = 'GENERIC STOP LIST'
order by 1 asc, 2 asc;

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









