19.28 STRINGIFY Function Signature 2

This function converts a number to an escaped JSON value.

Syntax

APEX_JSON.STRINGIFY (
    p_value  IN NUMBER )
RETURN VARCHAR2;

Parameters

Table 19-33 STRINGIFY Function Parameters

Parameter	Description
`p_value`	The number to be converted.

Returns

Table 19-34 STRINGIFY Function Returns

Return	Description
`VARCHAR2`	The converted and escaped JSON value.

Example

This example is a query that returns a JSON number value.

select apex_json.stringify(-1/10) from dual

Parent topic: APEX_JSON