GBP with TO_CHAR

View All Public Scripts Login to Run Script

Statement 1

ALTER SESSION SET NLS_TERRITORY = "UNITED KINGDOM"

Statement processed.

Statement 2

SELECT TO_CHAR(1111, 'FML9999') FROM DUAL


TO_CHAR(1111,'FML9999')
£1111

TO_CHAR(1111,'FML9999')
£1111

Statement 3

select *
from   nls_database_parameters
ORDER BY parameter


PARAMETER VALUE
NLS_NCHAR_CHARACTERSET AL16UTF16
NLS_CHARACTERSET AL32UTF8

2 rows selected.

PARAMETER	VALUE
NLS_NCHAR_CHARACTERSET	AL16UTF16
NLS_CHARACTERSET	AL32UTF8

Statement 4

select *
from   nls_session_parameters
ORDER BY parameter

Additional Information