ORA-00936:缺少使用管道的表达式

Question

有人能告诉我我的代码出了什么问题吗？我正在尝试使用管道，我计划对其进行整理，使其比普通文本部分更流畅一些，但我想知道为什么它现在不能工作。

    SELECT
    CUSTOMER.CUSTOMER_NO ||'Customer Number'||
    CUSTOMER.FIRST_NAME ||' First name '||
    CUSTOMER.SURNAME ||'Last name'||
    CAR.MAKE ||'Make'||
    CAR.MODEL ||'Model'||
    CAR.CAR_NO ||' '|| 
    CAR.PURCHASE_PRICE ||'Price Bought'|| 
    CAR.SOLD_PRICE ||'Price Sold'||
    CAR.SOLD_PRICE - CAR.PURCHASE_PRICE ||'Profit'||
    STAFF.FIRST_NAME ||' '||
    STAFF.STAFF_NO ||' '||

    AS "All sales in July 2015"

    FROM CUSTOMER, CAR, STAFF
    WHERE CAR.SOLD_BY_CUSTOMER_NO = CUSTOMER.CUSTOMER_NO AND SOLD_DATE                  between '07/01/2015' AND '07/31/2015' AND STAFF.STAFF_NO = CAR.SOLD_BY_STAFF_NO;

Answer 1

只需移除最后一条管道，如下所示

SELECT
    CUSTOMER.CUSTOMER_NO ||'Customer Number'||
    CUSTOMER.FIRST_NAME ||' First name '||
    CUSTOMER.SURNAME ||'Last name'||
    CAR.MAKE ||'Make'||
    CAR.MODEL ||'Model'||
    CAR.CAR_NO ||' '|| 
    CAR.PURCHASE_PRICE ||'Price Bought'|| 
    CAR.SOLD_PRICE ||'Price Sold'||
    CAR.SOLD_PRICE - CAR.PURCHASE_PRICE ||'Profit'||
    STAFF.FIRST_NAME ||' '||
    STAFF.STAFF_NO ||' '

    AS "All sales in July 2015"

    FROM CUSTOMER, CAR, STAFF
    WHERE CAR.SOLD_BY_CUSTOMER_NO = CUSTOMER.CUSTOMER_NO AND SOLD_DATE                  between '07/01/2015' AND '07/31/2015' AND STAFF.STAFF_NO = CAR.SOLD_BY_STAFF_NO;