Import JSON string to SQL tabular row-column format 

this will work 2016 and above

@@SQLwithManoj Thank you very much, your video solved my problem. Appreciated.

This code is for Microsoft SQL Server 2016 and above. Oracle might have other/similar syntax for this.

@@SQLwithManoj ok then of you have any idea in how to do Oracle 12 c to convert all table data in single row of Jason format....i need it

@@antonybabu5205 Oracle has following functions to convert rows to json string: json_array, json_arrayagg, json_object, json_objectagg Check this article for more details: blogs.oracle.com/sql/post/how-to-store-query-and-create-json-documents-in-oracle-database#generate-json

@@SQLwithManoj ok then...but orcale 11 g is not supported this syntax what can i do

@@antonybabu5205 you need to either upgrade to 21c version, or write custom code in PL/SQL to do the same but it will be too much complex.

no, this syntax is just for SQL Server