Which semi structured data function interprets an input string as a JSON document, producing a VARIANT value.

Which semi structured data function interprets an input string as a JSON document, producing a VARIANT value.
A . PARSE_JSON
B. PARSE_XML
C. STRIP_JSON

View Answer

Answer: A

Explanation:

Try a hands-on exercise to understand this

create or replace table vartab (n number(2), v variant); insert into vartab

select column1 as n, parse_json(column2) as v

from values (1, ‘null’),

(2, null),

(3, ‘true’),

(4, ‘-17’),

(7, ‘"Om ara pa ca na dhih" ‘),

(8, ‘[-1, 12, 289, 2188, false,]’),

(9, ‘{ "x" : "abc", "y" : false, "z": 10} ‘)

as vals;

select n, v, typeof(v) from vartab;