numformat

[kris123]

Hi,

How can I set the "numformat" parameter within PL/SQL block?

In SQL> prompt we can set numformat "000.00"

If you select amount from tab1 with value 1000
it will be selected as 1000.00

Can I do this on PL/SQL triggers?


Thanks

[Shestakov]

Use:

select to_char(1000, '9999D99') from dual;