Oracle 11g Release 2

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
select 'The repair to appliance ' || appliance.serialNo 
       || ' ' || appliance.appDesc || ', sold on ' ||
       LTRIM(to_char(appliance.appSaleDate,'ddth Month YYYY','NLS_DATE_language=American'), 0)
       || ' to ' || UPPER(Customer.custName) || ', to solve the issue' 
       || descripton_column || ' '  issue DVD || ' will cost ' 
       || to_char(cost_column, 'L9990.99')
from appliance 
inner join appRepair ON appliance.serialNo=appRepair.serialNo
inner join Customer ON appRepair.customer_id=Customer.custID;
ORA-00923: FROM keyword not found where expected

select 'The repair to appliance ' || '9001'
       || ' ' || 'DVD Player' || ', sold on ' ||
       LTRIM(to_char(sysdate,'ddth Month YYYY','NLS_DATE_language=American'), 0)
       || ' to ' || 'A.GREEN' || ', to solve the issue' 
       || 'DVD stuck' || ' will cost ' 
       || ltrim(to_char(67.50, 'L9990.99'))
from dual;


'THEREPAIRTOAPPLIANCE'||'9001'||''||'DVDPLAYER'||',SOLDON'||LTRIM(TO_CHAR(SYSDATE,'DDTHMONTHYYYY','NLS_DATE_LANGUAGE=AMERICAN'),0)||'TO'||'A.GREEN'||',TOSOLVETHEISSUE'||'DVDSTUCK'||'WILLCOST'||LTRIM(TO_CHAR(67.50,'L9990.99'))


The repair to appliance 9001 DVD Player, sold on 2nd November  2019 to A.GREEN, to solve the issueDVD stuck will cost $67.50


"The repair to appliance 9001 DVD Player
, sold on 1ST JANUARY 2018 to A.GREEN, to solve the issue DVD Stuck will cost €67.50".
ORA-00972: identifier is too long

select LTRIM(to_char(sysdate,'ddth Month YYYY','NLS_DATE_language=American'), 0) from dual


LTRIM(TO_CHAR(SYSDATE,'DDTHMONTHYYYY','NLS_DATE_LANGUAGE=AMERICAN'),0)


2nd November  2019


select to_char(00.00, 'L990.99') from dual;


TO_CHAR(00.00,'L990.99')


            $0.00