Hi,
I'm using ApEx 4 and in application created page with interactive report. In column 'Telefon_direktni' is showing phone number in format (0xx) xxx-xxx ( telephone numbers for Croatia). When i enter phone number i enter just 9 digits, so SQL select query puts () and - in report results. When i have 2 phone numbers i just enter 18 digits, and select query split number in format (0xx) xxx-xxx, (0xx) xxx-xxx. But my problem is here... in interactive report result for 2 phone numbers looks like this:
(0xx) xxx-xxx, (0xx)
xxx-xxx
I want thet result looks like this:
(0xx) xxx-xxx,
(0xx) xxx-xxx
How can i put break line in select query after ',' so it looks like i want.
This is my select statement:
select
case when LR.TELEFON_DIREKTNI is not null and LR.TELEFON_DIREKTNI like('_1%') and length(LR.TELEFON_DIREKTNI) < 10 then
'('||substr(LR.TELEFON_DIREKTNI,1,2)||') '||substr(LR.TELEFON_DIREKTNI,3,3)||'-'||substr(LR.TELEFON_DIREKTNI,6,4)
when LR.TELEFON_DIREKTNI is not null and LR.TELEFON_DIREKTNI like('_1%') and length(LR.TELEFON_DIREKTNI) > 10 then
'('||substr(LR.TELEFON_DIREKTNI,1,2)||')'||substr(LR.TELEFON_DIREKTNI,3,3)||'-'||substr(LR.TELEFON_DIREKTNI,6,4)||', '||'('||substr(LR.TELEFON_DIREKTNI,10,2)||') '||substr(LR.TELEFON_DIREKTNI,12,3)||'-'||substr(LR.TELEFON_DIREKTNI,15,4)
when LR.TELEFON_DIREKTNI is not null and LR.TELEFON_DIREKTNI not like('_1%') and length(LR.TELEFON_DIREKTNI) < 10 then
'('||substr(LR.TELEFON_DIREKTNI,1,3)||') '||substr(LR.TELEFON_DIREKTNI,4,3)||'-'||substr(LR.TELEFON_DIREKTNI,7,3)
when LR.TELEFON_DIREKTNI is not null and LR.TELEFON_DIREKTNI not like('_1%') and length(LR.TELEFON_DIREKTNI) > 10 then
'('||substr(LR.TELEFON_DIREKTNI,1,3)||')'||substr(LR.TELEFON_DIREKTNI,4,3)||'-'||substr(LR.TELEFON_DIREKTNI,7,3)||', ('||substr(LR.TELEFON_DIREKTNI,10,3)||') '||substr(LR.TELEFON_DIREKTNI,13,3)||'-'||substr(LR.TELEFON_DIREKTNI,16,3)
end as TELEFON_DIREKTNI
Edited by: user10410320 on Mar 30, 2011 10:14 AM