shaurya jain <12345shaurya@gmail.com> writes:
> But while we checking the same thing in Oracle it doesn't accept this. Is
> it an issue with Postgres data type?
I'd call it an issue with Oracle.
We follow RFC 7159, which specifies that "bare" scalars (numbers,
strings, booleans) are valid JSON values. I see though that it
says
A JSON text is a serialized value. Note that certain previous
specifications of JSON constrained a JSON text to be an object or an
array.
so apparently Oracle is following some obsolete version of the spec.
regards, tom lane