APEX

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

How to insert a carriage return in a select query for a calendar

Christian PitetJun 18 2020 — edited Jun 19 2020

Hi,

On a calendar I try to insert a carriage return in the sql query for the calendar, but when the calendar is diplayed, the carriage retrun is not rendered.

select a.PK, a.pk "Primary key",

   b.nom\_vehicule || ' ' || b.immatriculation || ' - ' || b.STATIONNEMENT || chr(13)  ||

   INITCAP(REPLACE( SUBSTR(CREE\_PAR, 0, INSTR(CREE\_PAR, '@')-1), '.', ' '))  "Véhicule",

   a.DATE\_DEBUT "DATE\_DEBUT",

   a.DATE\_FIN,

   c.email

from DT_AGENDA a, dt_vehicule b, dt_proprietaire c

where a.vehicule = b.pk

and b.proprietaire = c.pk

and b.residence = :P47_RESIDENCE

Snap 2020-06-18 at 16.24.24.png

Best regards.

Christian

This post has been answered by InoL on Jun 18 2020

Jump to Answer

Added on Jun 18 2020

#apex-discussions

5 comments

664 views