您能建议我如何执行查询以获得预期结果吗？下面我们可以看到实际和预期的输出结果。

WITH constants as (
    select  
        '' NA,'1.7' version,'test' needBrand,' ' needIdNbr,'cox  ' needFirstName,' ' needMiddleName,'simson' needLastName,' ' needNameSuffix,'10115 Jeffreys St' needAddrLine1,' ' needAddrLine2,'Las Vegas' needCity,'NV' needState,'89183' needZipCode,' ' needCountry,'1000047710' needPhoneNbr,'tcc_04@test.com' needEmailAddr,' ' USAGE
    from dual    
)
SELECT  constants.version AS version,TO_CHAR(current_timestamp,'YYYY/MM/DD hh24:mi:ss') AS extractDate,constants.needBrand AS needBrand,constants.needIdNbr AS needIdNbr,constants.needFirstName AS needFirstName,constants.needMiddleName AS needMiddleName,constants.needLastName AS needLastName,constants.needNameSuffix AS needNameSuffix,constants.needAddrLine1 AS needAddrLine1,constants.needAddrLine2 AS needAddrLine2,constants.needCity AS needCity,constants.needState AS needState,constants.needZipCode AS needZipCode,constants.needCountry AS needCountry,constants.needPhoneNbr AS needPhoneNbr,constants.needEmailAddr AS needEmailAddr,constants.USAGE AS USAGE,UPPER(user_status) AS Status,UPPER(user_type) AS Type,TO_CHAR(CREATED,'MM/DD/YYYY') AS Date 
     from usertitle ue,constants

实际输出：

version      needFirstName            Status                   Type 
--------     -------------           ------------             -------- ...etc
  1             David                Cancelled_pending        SHOEBOX 
  1             james                Subscribed_Pending       giftBox

预期的输出：在运行查询时，我们希望获得以下结果。状态为“ _”，并且在“类型”列中需要空格。

Version      needFirstName          Status                   Type 
--------     -------------        ------------              -------- ... etc
   1            David             Cancelled pending         SHOE BOX 
   1            james             Subscribed Pending        gift Box