Quite a childish question, but something I did not google on the move. request

SELECT '<row> \t\t<PRMT_ID>'||PRMT_ID||'</PRMT_ID> </row>' FROM MYTABLE

works by actually issuing combinations of \ t characters instead of a single tab character. How to insert a tab character there? While the most slender version of this

 SELECT '<row> '||CHR(9)||CHR(9)||'<PRMT_ID>'||PRMT_ID||'</PRMT_ID> </row>' FROM MYTABLE

But it looks something not very slim.

  • Why do you need tabs at all? XML ignores them anyway - Herman Borisov
  • And man does not ignore. For aesthetics, yeah. - Vitaly Jandulov

0