4.2.1
thm 2
Hi Everyone,
I was trying to add some space on a display item value using something like this
This is in the source of the display item
select rpad(table_column,10, ' ') from table.
It shows the values minus the rpad whitespace (works fine on sqlplus)
but if I put something like
select rpad(table_column,10, ' X ') from table. Then it adds the XX properly.
I changed the display item setting
Escape special characters to - >no and restricted characters -> All characters allowed for that display item. Still it removes the whitespaces. Any alternatives or ways to do this?
thanks!