ORACLE multiple columns merged into a single row of data wm_concat functions and replace

SELECT(--SELECT REPLACE (sbpt. parkstime| | ' ~ ' | | Sbpt. Parketime, ', ') replace can also  SELECTWm_concat (sbpt. Parkstime||'~'||sbpt. Parketime) Saree fromSys_berthandtype SBT Left JOINsys_berthtypeparktime sbpt onSBT. Berthtypeid=Sbpt. BerthtypeidWHEREBerthcode='114163'  andsbpt. Datetype= 1  andSbpt. Isallow= 2) Notallowtimespan, Wm_concat (SUBSTR (To_char (Freestarttime,'YYYY-MM-DD HH24:MI:SS'), One,9)||'~'||SUBSTR (To_char (Freeendtime,'YYYY-MM-DD HH24:MI:SS'), One,9)) Freetimespan fromTra_pricingberth TPB Left JOINTra_pricingfree TPF onTPB. Pricingstrategyid=TPF. PricingstrategyidWHEREBerthcode='114163'  andFreedatetype=1 GROUP  byBerthcode

Wm_concat merged into a row data column data volume assembly exceeds character length

SELECT wm_concat (sbpt. Parkstime| | ' ~ ' ||  from Sys_berthtypeparktime SBPT

REPLACE into multiple columns

SELECT  REPLACE (SBPT. Parkstime| | ' ~ ' || Sbpt. Parketime,',' from Sys_berthtypeparktime sbpt

ORACLE multiple columns merged into a single row of data wm_concat functions and replace