How to convert Numbers to Words in PLSQL

Rumesh Aponso (RMAX)

Nov 22, 20241 min read

--julian date must be between 1 and 5373484
SELECT 12358, (TO_CHAR(TO_DATE(12358, 'j'), 'jsp')) FROM DUAL

Output:

Related Links:

Example 1: SELECT DISTINCT LISTAGG(t.commission_receiver, ';') WITHIN GROUP (ORDER BY t.commission_receiver) FROM...

FUNCTION Strip_Ora_Error ( sqlerrm_ IN VARCHAR2, sqlcode_ IN NUMBER DEFAULT NULL, strip_ora_only_ IN BOOLEAN DEFAULT...

Example 1: SELECT handling_unit_id, t.shipment_id FROM handling_unit_tab t START WITH handling_unit_id = '4558' CONNECT BY PRIOR...

Related Posts