scripts/LJCOPY/COUNT_SRCH_CHAR_VAL-POSTSP3.sql

set serveroutput on
set pagesize 0
set trimspool on
set feedback off
SPOOL 'COUNT_SRCH_CHAR_VAL-POSTSP3.log';

DECLARE
    v_cnt         NUMBER;
BEGIN
	SELECT COUNT(*)
	INTO v_cnt
	FROM C1_CALC_GRP_CHAR A 
	WHERE TRIM(SRCH_CHAR_VAL) IS NOT NULL AND SRCH_CHAR_VAL like '% ';

	DBMS_OUTPUT.PUT_LINE('C1_CALC_GRP_CHAR: ' || v_cnt);
END;
/

DECLARE
    v_cnt         NUMBER;
BEGIN
	SELECT COUNT(*)
	INTO v_cnt
	FROM C1_CALC_RULE_CHAR A 
	WHERE TRIM(SRCH_CHAR_VAL) IS NOT NULL AND SRCH_CHAR_VAL like '% '; 

	DBMS_OUTPUT.PUT_LINE('C1_CALC_RULE_CHAR: ' || v_cnt);
END;
/

DECLARE
    v_cnt         NUMBER;
BEGIN
    SELECT COUNT(*)
	INTO v_cnt
    FROM C1_CALC_RULE_CRT_CHAR A 
    WHERE TRIM(SRCH_CHAR_VAL) IS NOT NULL AND SRCH_CHAR_VAL like '% '; 

	DBMS_OUTPUT.PUT_LINE('C1_CALC_RULE_CRT_CHAR: ' || v_cnt);
END;
/

DECLARE
    v_cnt         NUMBER;
BEGIN    
    SELECT COUNT(*)
	INTO v_cnt
    FROM C1_CL_CAT_TYPE_CHAR A 
    WHERE TRIM(SRCH_CHAR_VAL) IS NOT NULL AND SRCH_CHAR_VAL like '% ';

	DBMS_OUTPUT.PUT_LINE('C1_CL_CAT_TYPE_CHAR: ' || v_cnt);
END;
/

DECLARE
    v_cnt         NUMBER;
BEGIN    
    SELECT COUNT(*)
	INTO v_cnt
    FROM C1_COMM_RTE_TYPE_CHAR A 
    WHERE TRIM(SRCH_CHAR_VAL) IS NOT NULL AND SRCH_CHAR_VAL like '% '; 

	DBMS_OUTPUT.PUT_LINE('C1_COMM_RTE_TYPE_CHAR: ' || v_cnt);
END;
/

DECLARE
    v_cnt         NUMBER;
BEGIN    
    SELECT COUNT(*)
	INTO v_cnt
    FROM C1_INITIATIVE_CHAR A 
    WHERE TRIM(SRCH_CHAR_VAL) IS NOT NULL AND SRCH_CHAR_VAL like '% '; 

	DBMS_OUTPUT.PUT_LINE('C1_INITIATIVE_CHAR: ' || v_cnt);
END;
/

DECLARE
    v_cnt         NUMBER;
BEGIN    
    SELECT COUNT(*)
	INTO v_cnt
    FROM C1_INITIATIVE_CRITERIA_CHAR A 
    WHERE TRIM(SRCH_CHAR_VAL) IS NOT NULL AND SRCH_CHAR_VAL like '% '; 
   
	DBMS_OUTPUT.PUT_LINE('C1_INITIATIVE_CRITERIA_CHAR: ' || v_cnt);
END;
/

DECLARE
    v_cnt         NUMBER;
BEGIN  
    SELECT COUNT(*)
	INTO v_cnt
    FROM C1_ISS_CTR_CHAR A 
    WHERE TRIM(SRCH_CHAR_VAL) IS NOT NULL AND SRCH_CHAR_VAL like '% '; 
   
	DBMS_OUTPUT.PUT_LINE('C1_ISS_CTR_CHAR: ' || v_cnt);
END;
/

DECLARE
    v_cnt         NUMBER;
BEGIN  
    SELECT COUNT(*)
	INTO v_cnt
    FROM C1_LEAD_CHAR A 
    WHERE TRIM(SRCH_CHAR_VAL) IS NOT NULL AND SRCH_CHAR_VAL like '% ';
   
	DBMS_OUTPUT.PUT_LINE('C1_LEAD_CHAR: ' || v_cnt);
END;
/

DECLARE
    v_cnt         NUMBER;
BEGIN    			
    SELECT COUNT(*)
	INTO v_cnt
    FROM C1_LEAD_EVT_CHAR A
    WHERE TRIM(SRCH_CHAR_VAL) IS NOT NULL AND SRCH_CHAR_VAL like '% ';
   
	DBMS_OUTPUT.PUT_LINE('C1_LEAD_EVT_CHAR: ' || v_cnt);
END;
/

DECLARE
    v_cnt         NUMBER;
BEGIN    
    SELECT COUNT(*)
	INTO v_cnt
    FROM C1_LEAD_EVT_TYPE_CHAR A
    WHERE TRIM(SRCH_CHAR_VAL) IS NOT NULL AND SRCH_CHAR_VAL like '% ';
  
	DBMS_OUTPUT.PUT_LINE('C1_LEAD_EVT_TYPE_CHAR: ' || v_cnt);
END;
/

DECLARE
    v_cnt         NUMBER;
BEGIN   
    SELECT COUNT(*)
	INTO v_cnt
    FROM C1_NTF_PREF_CHAR A
    WHERE TRIM(SRCH_CHAR_VAL) IS NOT NULL AND SRCH_CHAR_VAL like '% ';
  
	DBMS_OUTPUT.PUT_LINE('C1_NTF_PREF_CHAR: ' || v_cnt);
END;
/

DECLARE
    v_cnt         NUMBER;
BEGIN   
    SELECT COUNT(*)
	INTO v_cnt
    FROM C1_NTF_TYPE_CHAR A
    WHERE TRIM(SRCH_CHAR_VAL) IS NOT NULL AND SRCH_CHAR_VAL like '% ';
  
	DBMS_OUTPUT.PUT_LINE('C1_NTF_TYPE_CHAR: ' || v_cnt);
END;
/

DECLARE
    v_cnt         NUMBER;
BEGIN   
    SELECT COUNT(*)
	INTO v_cnt
    FROM C1_OFFCYC_BGEN_CHAR A
    WHERE TRIM(SRCH_CHAR_VAL) IS NOT NULL AND SRCH_CHAR_VAL like '% ';
   
	DBMS_OUTPUT.PUT_LINE('C1_OFFCYC_BGEN_CHAR: ' || v_cnt);
END;
/

DECLARE
    v_cnt         NUMBER;
BEGIN  
    SELECT COUNT(*)
	INTO v_cnt
    FROM C1_REPRESENTATIVE_CHAR A
    WHERE TRIM(SRCH_CHAR_VAL) IS NOT NULL AND SRCH_CHAR_VAL like '% ';
   
	DBMS_OUTPUT.PUT_LINE('C1_REPRESENTATIVE_CHAR: ' || v_cnt);
END;
/

DECLARE
    v_cnt         NUMBER;
BEGIN  
    SELECT COUNT(*)
	INTO v_cnt
    FROM C1_TOU_MAP_CHAR A
    WHERE TRIM(SRCH_CHAR_VAL) IS NOT NULL AND SRCH_CHAR_VAL like '% ';
   
	DBMS_OUTPUT.PUT_LINE('C1_TOU_MAP_CHAR: ' || v_cnt);
END;
/

DECLARE
    v_cnt         NUMBER;
BEGIN   
    SELECT COUNT(*)
	INTO v_cnt
    FROM C1_TOU_MAP_DATA_CHAR A
    WHERE TRIM(SRCH_CHAR_VAL) IS NOT NULL AND SRCH_CHAR_VAL like '% ';
   
	DBMS_OUTPUT.PUT_LINE('C1_TOU_MAP_DATA_CHAR: ' || v_cnt);
END;
/

DECLARE
    v_cnt         NUMBER;
BEGIN 
    SELECT COUNT(*)
	INTO v_cnt
    FROM C1_TOU_MAP_TMPLT_CHAR A
    WHERE TRIM(SRCH_CHAR_VAL) IS NOT NULL AND SRCH_CHAR_VAL like '% ';
    
	DBMS_OUTPUT.PUT_LINE('C1_TOU_MAP_TMPLT_CHAR: ' || v_cnt);
END;
/

DECLARE
    v_cnt         NUMBER;
BEGIN 
    SELECT COUNT(*)
	INTO v_cnt
    FROM C1_TOU_MAP_TYPE_CHAR A
    WHERE TRIM(SRCH_CHAR_VAL) IS NOT NULL AND SRCH_CHAR_VAL like '% ';
   
	DBMS_OUTPUT.PUT_LINE('C1_TOU_MAP_TYPE_CHAR: ' || v_cnt);
END;
/

DECLARE
    v_cnt         NUMBER;
BEGIN  
    SELECT COUNT(*)
	INTO v_cnt
    FROM C1_USAGE_CHAR A
    WHERE TRIM(SRCH_CHAR_VAL) IS NOT NULL AND SRCH_CHAR_VAL like '% ';
    
	DBMS_OUTPUT.PUT_LINE('C1_USAGE_CHAR: ' || v_cnt);
END;
/

DECLARE
    v_cnt         NUMBER;
BEGIN  
    SELECT COUNT(*)
	INTO v_cnt
    FROM CI_ACCT_CHAR A
    WHERE TRIM(SRCH_CHAR_VAL) IS NOT NULL AND SRCH_CHAR_VAL like '% ';
   
	DBMS_OUTPUT.PUT_LINE('CI_ACCT_CHAR: ' || v_cnt);
END;
/

DECLARE
    v_cnt         NUMBER;
BEGIN  
    SELECT COUNT(*)
	INTO v_cnt
    FROM CI_ADJ_CHAR A
    WHERE TRIM(SRCH_CHAR_VAL) IS NOT NULL AND SRCH_CHAR_VAL like '% ';
   
	DBMS_OUTPUT.PUT_LINE('CI_ADJ_CHAR: ' || v_cnt);
END;
/

DECLARE
    v_cnt         NUMBER;
BEGIN   
    SELECT COUNT(*)
	INTO v_cnt
    FROM CI_ADJ_STG_CTL_CHAR A
    WHERE TRIM(SRCH_CHAR_VAL) IS NOT NULL AND SRCH_CHAR_VAL like '% ';
  
	DBMS_OUTPUT.PUT_LINE('CI_ADJ_STG_CTL_CHAR: ' || v_cnt);
END;
/

DECLARE
    v_cnt         NUMBER;
BEGIN    
    SELECT COUNT(*)
	INTO v_cnt
    FROM CI_ADJ_STG_UP_CHAR A
    WHERE TRIM(SRCH_CHAR_VAL) IS NOT NULL AND SRCH_CHAR_VAL like '% ';
  
	DBMS_OUTPUT.PUT_LINE('CI_ADJ_STG_UP_CHAR: ' || v_cnt);
END;
/

DECLARE
    v_cnt         NUMBER;
BEGIN   
    SELECT COUNT(*)
	INTO v_cnt
    FROM CI_APPR_REQ_CHAR A
    WHERE TRIM(SRCH_CHAR_VAL) IS NOT NULL AND SRCH_CHAR_VAL like '% ';
  
	DBMS_OUTPUT.PUT_LINE('CI_APPR_REQ_CHAR: ' || v_cnt);
END;
/

DECLARE
    v_cnt         NUMBER;
BEGIN   
    SELECT COUNT(*)
	INTO v_cnt
    FROM CI_BILL_CHAR A
    WHERE TRIM(SRCH_CHAR_VAL) IS NOT NULL AND SRCH_CHAR_VAL like '% ';
 
	DBMS_OUTPUT.PUT_LINE('CI_BILL_CHAR: ' || v_cnt);
END;
/

DECLARE
    v_cnt         NUMBER;
BEGIN     
    SELECT COUNT(*)
	INTO v_cnt
    FROM CI_CASE_CHAR A
    WHERE TRIM(SRCH_CHAR_VAL) IS NOT NULL AND SRCH_CHAR_VAL like '% ';
	DBMS_OUTPUT.PUT_LINE('CI_CASE_CHAR: ' || v_cnt);
END;
/

DECLARE
    v_cnt         NUMBER;
BEGIN    
    SELECT COUNT(*)
	INTO v_cnt
    FROM CI_CC_CHAR A
    WHERE TRIM(SRCH_CHAR_VAL) IS NOT NULL AND SRCH_CHAR_VAL like '% ';
 
	DBMS_OUTPUT.PUT_LINE('CI_CC_CHAR: ' || v_cnt);
END;
/

DECLARE
    v_cnt         NUMBER;
BEGIN   
    SELECT COUNT(*)
	INTO v_cnt
    FROM CI_CONSV_PROG_CHAR A
    WHERE TRIM(SRCH_CHAR_VAL) IS NOT NULL AND SRCH_CHAR_VAL like '% ';
 
	DBMS_OUTPUT.PUT_LINE('CI_CONSV_PROG_CHAR: ' || v_cnt);
END;
/

DECLARE
    v_cnt         NUMBER;
BEGIN    
    SELECT COUNT(*)
	INTO v_cnt
    FROM CI_DEP_CTL_CHAR A
    WHERE TRIM(SRCH_CHAR_VAL) IS NOT NULL AND SRCH_CHAR_VAL like '% ';
 
	DBMS_OUTPUT.PUT_LINE('CI_DEP_CTL_CHAR: ' || v_cnt);
END;
/

DECLARE
    v_cnt         NUMBER;
BEGIN   
    SELECT COUNT(*)
	INTO v_cnt
    FROM CI_FA_CHAR A
    WHERE TRIM(SRCH_CHAR_VAL) IS NOT NULL AND SRCH_CHAR_VAL like '% ';
 
	DBMS_OUTPUT.PUT_LINE('CI_FA_CHAR: ' || v_cnt);
END;
/

DECLARE
    v_cnt         NUMBER;
BEGIN     
    SELECT COUNT(*)
	INTO v_cnt
    FROM CI_ITEM_CHAR A
    WHERE TRIM(SRCH_CHAR_VAL) IS NOT NULL AND SRCH_CHAR_VAL like '% ';
	DBMS_OUTPUT.PUT_LINE('CI_ITEM_CHAR: ' || v_cnt);
END;
/

DECLARE
    v_cnt         NUMBER;
BEGIN    
    SELECT COUNT(*)
	INTO v_cnt
    FROM CI_MKTMSG_TYPE_CHAR A
    WHERE TRIM(SRCH_CHAR_VAL) IS NOT NULL AND SRCH_CHAR_VAL like '% ';
 
	DBMS_OUTPUT.PUT_LINE('CI_MKTMSG_TYPE_CHAR: ' || v_cnt);
END;
/

DECLARE
    v_cnt         NUMBER;
BEGIN    
    SELECT COUNT(*)
	INTO v_cnt
    FROM CI_MR_CHAR A
    WHERE TRIM(SRCH_CHAR_VAL) IS NOT NULL AND SRCH_CHAR_VAL like '% ';
	DBMS_OUTPUT.PUT_LINE('CI_MR_CHAR: ' || v_cnt);
END;
/

DECLARE
    v_cnt         NUMBER;
BEGIN     
    SELECT COUNT(*)
	INTO v_cnt
    FROM CI_MR_RTE_CHAR A
    WHERE TRIM(SRCH_CHAR_VAL) IS NOT NULL AND SRCH_CHAR_VAL like '% ';
	DBMS_OUTPUT.PUT_LINE('CI_MR_RTE_CHAR: ' || v_cnt);
END;
/

DECLARE
    v_cnt         NUMBER;
BEGIN     
    SELECT COUNT(*)
	INTO v_cnt
    FROM CI_MR_STGUP_CHAR A
    WHERE TRIM(SRCH_CHAR_VAL) IS NOT NULL AND SRCH_CHAR_VAL like '% ';
	DBMS_OUTPUT.PUT_LINE('CI_MR_STGUP_CHAR: ' || v_cnt);
END;
/

DECLARE
    v_cnt         NUMBER;
BEGIN     
    SELECT COUNT(*)
	INTO v_cnt
    FROM CI_MTR_CHAR A
    WHERE TRIM(SRCH_CHAR_VAL) IS NOT NULL AND SRCH_CHAR_VAL like '% ';
	DBMS_OUTPUT.PUT_LINE('CI_MTR_CHAR: ' || v_cnt);
END;
/

DECLARE
    v_cnt         NUMBER;
BEGIN     
    SELECT COUNT(*)
	INTO v_cnt
    FROM CI_NT_DWN_CHAR A
    WHERE TRIM(SRCH_CHAR_VAL) IS NOT NULL AND SRCH_CHAR_VAL like '% ';
	DBMS_OUTPUT.PUT_LINE('CI_NT_DWN_CHAR: ' || v_cnt);
END;
/

DECLARE
    v_cnt         NUMBER;
BEGIN     
    SELECT COUNT(*)
	INTO v_cnt
    FROM CI_PAY_CHAR A
    WHERE TRIM(SRCH_CHAR_VAL) IS NOT NULL AND SRCH_CHAR_VAL like '% ';

	DBMS_OUTPUT.PUT_LINE('CI_PAY_CHAR: ' || v_cnt);
END;
/

DECLARE
    v_cnt         NUMBER;
BEGIN     
    SELECT COUNT(*)
	INTO v_cnt
    FROM CI_PAY_EVT_CHAR A
    WHERE TRIM(SRCH_CHAR_VAL) IS NOT NULL AND SRCH_CHAR_VAL like '% ';
	DBMS_OUTPUT.PUT_LINE('CI_PAY_EVT_CHAR: ' || v_cnt);
END;
/

DECLARE
    v_cnt         NUMBER;
BEGIN     
    SELECT COUNT(*)
	INTO v_cnt
    FROM CI_PAY_TNDR_CHAR A
    WHERE TRIM(SRCH_CHAR_VAL) IS NOT NULL AND SRCH_CHAR_VAL like '% ';
	DBMS_OUTPUT.PUT_LINE('CI_PAY_TNDR_CHAR: ' || v_cnt);
END;
/

DECLARE
    v_cnt         NUMBER;
BEGIN    
    SELECT COUNT(*)
	INTO v_cnt
    FROM CI_PAY_TNDR_ST_CHAR A
    WHERE TRIM(SRCH_CHAR_VAL) IS NOT NULL AND SRCH_CHAR_VAL like '% ';
	DBMS_OUTPUT.PUT_LINE('CI_PAY_TNDR_ST_CHAR: ' || v_cnt);
END;
/

DECLARE
    v_cnt         NUMBER;
BEGIN    
    SELECT COUNT(*)
	INTO v_cnt
    FROM CI_PER_CHAR A
    WHERE TRIM(SRCH_CHAR_VAL) IS NOT NULL AND SRCH_CHAR_VAL like '% ';
	DBMS_OUTPUT.PUT_LINE('CI_PER_CHAR: ' || v_cnt);
END;
/

DECLARE
    v_cnt         NUMBER;
BEGIN    
    SELECT COUNT(*)
	INTO v_cnt
    FROM CI_PEVT_DST_DTL A
    WHERE TRIM(SRCH_CHAR_VAL) IS NOT NULL AND SRCH_CHAR_VAL like '% ';
	DBMS_OUTPUT.PUT_LINE('CI_PEVT_DST_DTL: ' || v_cnt);
END;
/

DECLARE
    v_cnt         NUMBER;
BEGIN    
    SELECT COUNT(*)
	INTO v_cnt
    FROM CI_PREM_CHAR A
    WHERE TRIM(SRCH_CHAR_VAL) IS NOT NULL AND SRCH_CHAR_VAL like '% ';

	DBMS_OUTPUT.PUT_LINE('CI_PREM_CHAR: ' || v_cnt);
END;
/

DECLARE
    v_cnt         NUMBER;
BEGIN    
    SELECT COUNT(*)
	INTO v_cnt
    FROM CI_REBATE_CLAIM_CHAR A
    WHERE TRIM(SRCH_CHAR_VAL) IS NOT NULL AND SRCH_CHAR_VAL like '% ';
	DBMS_OUTPUT.PUT_LINE('CI_REBATE_CLAIM_CHAR: ' || v_cnt);
END;
/

DECLARE
    v_cnt         NUMBER;
BEGIN    
    SELECT COUNT(*)
	INTO v_cnt
    FROM CI_REBATE_LINE_CHAR A
    WHERE TRIM(SRCH_CHAR_VAL) IS NOT NULL AND SRCH_CHAR_VAL like '% ';
	DBMS_OUTPUT.PUT_LINE('CI_REBATE_LINE_CHAR: ' || v_cnt);
END;
/

DECLARE
    v_cnt         NUMBER;
BEGIN    
    SELECT COUNT(*)
	INTO v_cnt
    FROM CI_REG_CHAR A
    WHERE TRIM(SRCH_CHAR_VAL) IS NOT NULL AND SRCH_CHAR_VAL like '% ';
	DBMS_OUTPUT.PUT_LINE('CI_REG_CHAR: ' || v_cnt);
END;
/

DECLARE
    v_cnt         NUMBER;
BEGIN    
    SELECT COUNT(*)
	INTO v_cnt
    FROM CI_SA_CHAR A
    WHERE TRIM(SRCH_CHAR_VAL) IS NOT NULL AND SRCH_CHAR_VAL like '% ';
	DBMS_OUTPUT.PUT_LINE('CI_SA_CHAR: ' || v_cnt);
END;
/

DECLARE
    v_cnt         NUMBER;
BEGIN    
    SELECT COUNT(*)
	INTO v_cnt
    FROM CI_SCM_CHAR A
    WHERE TRIM(SRCH_CHAR_VAL) IS NOT NULL AND SRCH_CHAR_VAL like '% ';
	DBMS_OUTPUT.PUT_LINE('CI_SCM_CHAR: ' || v_cnt);
END;
/

DECLARE
    v_cnt         NUMBER;
BEGIN    
    SELECT COUNT(*)
	INTO v_cnt
    FROM CI_SP_CHAR A
    WHERE TRIM(SRCH_CHAR_VAL) IS NOT NULL AND SRCH_CHAR_VAL like '% ';
	DBMS_OUTPUT.PUT_LINE('CI_SP_CHAR: ' || v_cnt);
END;
/

DECLARE
    v_cnt         NUMBER;
BEGIN    
    SELECT COUNT(*)
	INTO v_cnt
    FROM CI_STK_LOC_CHAR A
    WHERE TRIM(SRCH_CHAR_VAL) IS NOT NULL AND SRCH_CHAR_VAL like '% ';
	DBMS_OUTPUT.PUT_LINE('CI_STK_LOC_CHAR: ' || v_cnt);
END;
/

DECLARE
    v_cnt         NUMBER;
BEGIN    
    SELECT COUNT(*)
	INTO v_cnt
    FROM CI_TD_ENTRY_CHA A
    WHERE TRIM(SRCH_CHAR_VAL) IS NOT NULL AND SRCH_CHAR_VAL like '% ';
	DBMS_OUTPUT.PUT_LINE('CI_TD_ENTRY_CHA: ' || v_cnt);
END;
/

DECLARE
    v_cnt         NUMBER;
BEGIN    
    SELECT COUNT(*)
	INTO v_cnt
    FROM CI_TD_TYPE_CHAR A
    WHERE TRIM(SRCH_CHAR_VAL) IS NOT NULL AND SRCH_CHAR_VAL like '% ';
	DBMS_OUTPUT.PUT_LINE('CI_TD_TYPE_CHAR: ' || v_cnt);
END;
/

DECLARE
    v_cnt         NUMBER;
BEGIN    
    SELECT COUNT(*)
	INTO v_cnt
    FROM CI_TNDR_CTL_CHAR A
    WHERE TRIM(SRCH_CHAR_VAL) IS NOT NULL AND SRCH_CHAR_VAL like '% ';
	DBMS_OUTPUT.PUT_LINE('CI_TNDR_CTL_CHAR: ' || v_cnt);
END;
/

DECLARE
    v_cnt         NUMBER;
BEGIN    
    SELECT COUNT(*)
	INTO v_cnt
    FROM CI_TOS_CE A
    WHERE TRIM(SRCH_CHAR_VAL) IS NOT NULL AND SRCH_CHAR_VAL like '% ';
	DBMS_OUTPUT.PUT_LINE('CI_TOS_CE: ' || v_cnt);
END;
/

DECLARE
    v_cnt         NUMBER;
BEGIN    
    SELECT COUNT(*)
	INTO v_cnt
    FROM CI_TOS_CHAR A
    WHERE TRIM(SRCH_CHAR_VAL) IS NOT NULL AND SRCH_CHAR_VAL like '% ';
	DBMS_OUTPUT.PUT_LINE('CI_TOS_CHAR: ' || v_cnt);
END;
/

DECLARE
    v_cnt         NUMBER;
BEGIN    
    SELECT COUNT(*)
	INTO v_cnt
    FROM CI_UA_CHAR A
    WHERE TRIM(SRCH_CHAR_VAL) IS NOT NULL AND SRCH_CHAR_VAL like '% ';
	DBMS_OUTPUT.PUT_LINE('CI_UA_CHAR: ' || v_cnt);
END;
/

DECLARE
    v_cnt         NUMBER;
BEGIN    
    SELECT COUNT(*)
	INTO v_cnt
    FROM CI_WF_PROC_CHAR A
    WHERE TRIM(SRCH_CHAR_VAL) IS NOT NULL AND SRCH_CHAR_VAL like '% ';
	DBMS_OUTPUT.PUT_LINE('CI_WF_PROC_CHAR: ' || v_cnt);
END;
/

DECLARE
    v_cnt         NUMBER;
BEGIN    
    SELECT COUNT(*)
	INTO v_cnt
    FROM CM_DD_FILE_CHAR A
    WHERE TRIM(SRCH_CHAR_VAL) IS NOT NULL AND SRCH_CHAR_VAL like '% ';
	DBMS_OUTPUT.PUT_LINE('CM_DD_FILE_CHAR: ' || v_cnt);
END;
/

DECLARE
    v_cnt         NUMBER;
BEGIN    
    SELECT COUNT(*)
	INTO v_cnt
    FROM F1_ATTACHMENT_CHAR A
    WHERE TRIM(SRCH_CHAR_VAL) IS NOT NULL AND SRCH_CHAR_VAL like '% ';

	DBMS_OUTPUT.PUT_LINE('F1_ATTACHMENT_CHAR: ' || v_cnt);
END;
/

DECLARE
    v_cnt         NUMBER;
BEGIN    
    SELECT COUNT(*)
	INTO v_cnt
    FROM F1_BNDL_CHAR A
    WHERE TRIM(SRCH_CHAR_VAL) IS NOT NULL AND SRCH_CHAR_VAL like '% ';

	DBMS_OUTPUT.PUT_LINE('F1_BNDL_CHAR: ' || v_cnt);
END;
/

DECLARE
    v_cnt         NUMBER;
BEGIN    
    SELECT COUNT(*)
	INTO v_cnt
    FROM F1_BUS_EVT_LOG_CHAR A
    WHERE TRIM(SRCH_CHAR_VAL) IS NOT NULL AND SRCH_CHAR_VAL like '% ';
	DBMS_OUTPUT.PUT_LINE('F1_BUS_EVT_LOG_CHAR: ' || v_cnt);
END;
/

DECLARE
    v_cnt         NUMBER;
BEGIN    
    SELECT COUNT(*)
	INTO v_cnt
    FROM F1_BUS_OBJ_STATUS_RSN_CHAR A
    WHERE TRIM(SRCH_CHAR_VAL) IS NOT NULL AND SRCH_CHAR_VAL like '% ';
	DBMS_OUTPUT.PUT_LINE('F1_BUS_OBJ_STATUS_RSN_CHAR: ' || v_cnt);
END;
/

DECLARE
    v_cnt         NUMBER;
BEGIN    
    SELECT COUNT(*)
	INTO v_cnt
    FROM F1_FACT_CHAR A
    WHERE TRIM(SRCH_CHAR_VAL) IS NOT NULL AND SRCH_CHAR_VAL like '% ';
	DBMS_OUTPUT.PUT_LINE('F1_FACT_CHAR: ' || v_cnt);
END;
/

DECLARE
    v_cnt         NUMBER;
BEGIN    
    SELECT COUNT(*)
	INTO v_cnt
    FROM F1_GNRL_AUDIT_CHAR A
    WHERE TRIM(SRCH_CHAR_VAL) IS NOT NULL AND SRCH_CHAR_VAL like '% ';
 
	DBMS_OUTPUT.PUT_LINE('F1_GNRL_AUDIT_CHAR: ' || v_cnt);
END;
/

DECLARE
    v_cnt         NUMBER;
BEGIN    
    SELECT COUNT(*)
	INTO v_cnt
    FROM F1_IWS_SVC_CHAR A
    WHERE TRIM(SRCH_CHAR_VAL) IS NOT NULL AND SRCH_CHAR_VAL like '% ';
	DBMS_OUTPUT.PUT_LINE('F1_IWS_SVC_CHAR: ' || v_cnt);
END;
/

DECLARE
    v_cnt         NUMBER;
BEGIN    
    SELECT COUNT(*)
	INTO v_cnt
    FROM F1_OBJ_REV_CHAR A
    WHERE TRIM(SRCH_CHAR_VAL) IS NOT NULL AND SRCH_CHAR_VAL like '% ';
	DBMS_OUTPUT.PUT_LINE('F1_OBJ_REV_CHAR: ' || v_cnt);
END;
/

DECLARE
    v_cnt         NUMBER;
BEGIN    
    SELECT COUNT(*)
	INTO v_cnt
    FROM F1_REQ_CHAR A
    WHERE TRIM(SRCH_CHAR_VAL) IS NOT NULL AND SRCH_CHAR_VAL like '% ';
	DBMS_OUTPUT.PUT_LINE('F1_REQ_CHAR: ' || v_cnt);
END;
/

DECLARE
    v_cnt         NUMBER;
BEGIN    
    SELECT COUNT(*)
	INTO v_cnt
    FROM F1_SVC_TASK_CHAR A
    WHERE TRIM(SRCH_CHAR_VAL) IS NOT NULL AND SRCH_CHAR_VAL like '% ';
	DBMS_OUTPUT.PUT_LINE('F1_SVC_TASK_CHAR: ' || v_cnt);
END;
/

DECLARE
    v_cnt         NUMBER;
BEGIN    
    SELECT COUNT(*)
	INTO v_cnt
    FROM F1_SVC_TASK_TYPE_CHAR A
    WHERE TRIM(SRCH_CHAR_VAL) IS NOT NULL AND SRCH_CHAR_VAL like '% ';
	DBMS_OUTPUT.PUT_LINE('F1_SVC_TASK_TYPE_CHAR: ' || v_cnt);
END;
/

DECLARE
    v_cnt         NUMBER;
BEGIN    
    SELECT COUNT(*)
	INTO v_cnt
    FROM F1_SYNC_REQ_CHAR A
    WHERE TRIM(SRCH_CHAR_VAL) IS NOT NULL AND SRCH_CHAR_VAL like '% ';
	DBMS_OUTPUT.PUT_LINE('F1_SYNC_REQ_CHAR: ' || v_cnt);
END;
/

DECLARE
    v_cnt         NUMBER;
BEGIN    
    SELECT COUNT(*)
	INTO v_cnt
    FROM F1_SYNC_REQ_IN_CHAR A
    WHERE TRIM(SRCH_CHAR_VAL) IS NOT NULL AND SRCH_CHAR_VAL like '% ';
	DBMS_OUTPUT.PUT_LINE('F1_SYNC_REQ_IN_CHAR: ' || v_cnt);
END;
/

DECLARE
    v_cnt         NUMBER;
BEGIN    
    SELECT COUNT(*)
	INTO v_cnt
    FROM F1_WEB_SVC_CHAR A
    WHERE TRIM(SRCH_CHAR_VAL) IS NOT NULL AND SRCH_CHAR_VAL like '% ';
	DBMS_OUTPUT.PUT_LINE('F1_WEB_SVC_CHAR: ' || v_cnt);
END;
/

DECLARE
    v_cnt         NUMBER;
BEGIN    
    SELECT COUNT(*)
	INTO v_cnt
    FROM SC_USER_CHAR A
    WHERE TRIM(SRCH_CHAR_VAL) IS NOT NULL AND SRCH_CHAR_VAL like '% '; 

	DBMS_OUTPUT.PUT_LINE('SC_USER_CHAR: ' || v_cnt);
END;
/

SPOOL OFF;

EXIT;