json_extract_path_text()

Let us now check the json_extract_path_text(json text, json_path text) function with the following query.

Query

default> select json_extract_path_text('{"tutorial" : 
   {"key" : "tajo"}}','$.tutorial.key') as path;   

Result

The above query will generate the following result.

path 
------------------------------- 
tajo

The query extracts the JSON string “tutorial” from a JSON string based on the JSON path.