现有如下sybase数据库查询语句,需要对其排版:(源文件如下)
'Z002','PYM','
SELECT
SUBSTR(TO_CHAR(?),1, || NVL(TO_CHAR(A.TERRITORY,' ')...FROM SAP_AR_IPYM...
'Z002','REF','
SELECT
SUBSTR(TO_CHAR(?),1, || NVL(TO_CHAR(A.TERRITORY,' ')...FROM SAP_AR_IAAJ...
'Z001','PYE','
SELECT
SUBSTR(TO_CHAR(?),1, || NVL(TO_CHAR(A.TERRITORY,' '),RPAD(A.TERRITORY,2,' ')... FROM AS RSLT SAP_B_COMPANY_CARRIER...
需要变成
'Z002','PYM',' SELECT SUBSTR(TO_CHAR(?),1, || NVL(TO_CHAR(A.TERRITORY,' ')...FROM SAP_AR_IPYM...
'Z002','REF','SELECT SUBSTR(TO_CHAR(?),1, || NVL(TO_CHAR(A.TERRITORY,' ')...FROM SAP_AR_IAAJ...
'Z001','PYE','SELECT SUBSTR(TO_CHAR(?),1, || NVL(TO_CHAR(A.TERRITORY,' '),RPAD(A.TERRITORY,2,' ')... FROM AS RSLT SAP_B_COMPANY_CARRIER...
每行记录跟之前一样,句与句之间保持空格
|