如何在日志文件中显示参数值而不是问号 [英] how to display parameter values instead of question marks in log file

问题描述

如何在日志文件中显示参数值而不是问号，如下所示.

How to display parameter values instead of question marks in log file as below..

SELECT 
  CASE 
   WHEN (a.CNT = 0 AND b.cnt = 0) THEN 'N'
   ELSE  CASE  WHEN a.CNT = b.CNT THEN 'Y'
         ELSE 'N' END 
   END      AS Final_Status
FROM
  (SELECT NVL(COUNT(*),1) CNT
  FROM FPC_INFO
  WHERE BILL_MONTH_DT = ?
  AND CUST_TYPE_NM    = UPPER(?)
  AND FINALIZED_USER IS NOT NULL
  ) a,
  (SELECT COUNT(*) CNT
  FROM FPC_INFO
  WHERE BILL_MONTH_DT = ?
  AND CUST_TYPE_NM    = UPPER(?)
  ) b

我的期望是:

SELECT 
  CASE 
   WHEN (a.CNT = 0 AND b.cnt = 0) THEN 'N'
   ELSE  CASE  WHEN a.CNT = b.CNT THEN 'Y'
         ELSE 'N' END 
   END      AS Final_Status
FROM
  (SELECT NVL(COUNT(*),1) CNT
  FROM FPC_INFO
  WHERE BILL_MONTH_DT = '01-SEP-2015'
  AND CUST_TYPE_NM    = UPPER('UVERSE')
  AND FINALIZED_USER IS NOT NULL
  ) a,
  (SELECT COUNT(*) CNT
  FROM FPC_INFO
  WHERE BILL_MONTH_DT = '01-SEP-2015'
  AND CUST_TYPE_NM    = UPPER('UVERSE')
  ) b

推荐答案

很抱歉，未格式化的代码.

我在日志文件中收到带有如下问号的日志.

I'm getting log with question marks like below in Log file..

SELECT CASE WHEN (a.CNT = 0 AND b.cnt = 0) THEN 'N' ELSE CASE WHEN a.CNT = b.CNT THEN 'Y' ELSE 'N' END END AS Final_Status FROM (SELECT NVL(COUNT(),1) CNT FROM FPC_INFO WHERE BILL_MONTH_DT = ? AND CUST_TYPE_NM = UPPER(?) AND FINALIZED_USER IS NOT NULL) a, (SELECT COUNT() CNT FROM FPC_INFO WHERE BILL_MONTH_DT = ? AND CUST_TYPE_NM = UPPER(?)) b

SELECT CASE WHEN (a.CNT = 0 AND b.cnt = 0) THEN 'N' ELSE CASE WHEN a.CNT = b.CNT THEN 'Y' ELSE 'N' END END AS Final_Status FROM (SELECT NVL(COUNT(),1) CNT FROM FPC_INFO WHERE BILL_MONTH_DT = ? AND CUST_TYPE_NM = UPPER(?) AND FINALIZED_USER IS NOT NULL) a, (SELECT COUNT() CNT FROM FPC_INFO WHERE BILL_MONTH_DT = ? AND CUST_TYPE_NM = UPPER(?)) b

但是我希望它能像下面这样打印，并在日志文件中附加值:

But i'm expecting it to print like below with appended values in log file:

SELECT CASE WHEN (a.CNT = 0 AND b.cnt = 0) THEN 'N' ELSE CASE WHEN a.CNT = b.CNT THEN 'Y' ELSE 'N' END END AS Final_Status FROM (SELECT NVL(COUNT(),1) CNT FROM FPC_INFO WHERE BILL_MONTH_DT = '01-SEP-2015' AND CUST_TYPE_NM = UPPER('UVERSE') AND FINALIZED_USER IS NOT NULL) a, (SELECT COUNT() CNT FROM FPC_INFO WHERE BILL_MONTH_DT = '01-SEP-2015' AND CUST_TYPE_NM = UPPER('UVERSE')) b

SELECT CASE WHEN (a.CNT = 0 AND b.cnt = 0) THEN 'N' ELSE CASE WHEN a.CNT = b.CNT THEN 'Y' ELSE 'N' END END AS Final_Status FROM (SELECT NVL(COUNT(),1) CNT FROM FPC_INFO WHERE BILL_MONTH_DT = '01-SEP-2015' AND CUST_TYPE_NM = UPPER('UVERSE') AND FINALIZED_USER IS NOT NULL) a, (SELECT COUNT() CNT FROM FPC_INFO WHERE BILL_MONTH_DT = '01-SEP-2015' AND CUST_TYPE_NM = UPPER('UVERSE')) b

这篇关于如何在日志文件中显示参数值而不是问号的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！