<div>
There is an article about this problem:<br />
<a href="https://docs.microsoft.com/en-us/sql/relational-databases/json/convert-json-data-to-rows-and-columns-with-openjson-sql-server" rel="ugc">https://docs.microsoft.com<wbr />/en-us/sql<wbr />/relationa<wbr />l-database<wbr />s/json/con<wbr />vert-json-<wbr />data-to-ro<wbr />ws-and-col<wbr />umns-with-<wbr />openjson-s<wbr />ql-server</a>
</div>


There is an article about this problem:
https://docs.microsoft.com/en-us/sql/relational-databases/json/convert-json-data-to-rows-and-columns-with-openjson-sql-server [https://docs.microsoft.com/en-us/sql/relational-databases/json/convert-json-data-to-rows-and-columns-with-openjson-sql-server]

<div>
Which database engine? Above is about MS SQL 2016/Azure.<br />
<br />
<i>*** Topic added ***</i>
</div>


Which database engine? Above is about MS SQL 2016/Azure.

*** Topic added ***

<div>
I need any suggestions on how to use the json value in the select statement. Please advise
</div>


I need any suggestions on how to use the json value in the select statement. Please advise

<div>
I need some examples on how to read the value inside the json column and use that as condition to write the condition. Please suggest any article or examples.<br />
<br />
Your help is much appreciated.
</div>


I need some examples on how to read the value inside the json column and use that as condition to write the condition. Please suggest any article or examples.

Your help is much appreciated.

<div>
If you use ORACLE, you can read these articles:<br />
<a href="https://blogs.oracle.com/jsondb/the-new-sqljson-query-operators-part1:-jsonvalue" rel="ugc nofollow">https://blogs.oracle.com/j<wbr />sondb/the-<wbr />new-sqljso<wbr />n-query-op<wbr />erators-pa<wbr />rt1:-jsonv<wbr />alue</a><br />
<a href="https://docs.oracle.com/database/121/ADXDB/json.htm#ADXDB6371" rel="ugc">https://docs.oracle.com/da<wbr />tabase/121<wbr />/ADXDB/jso<wbr />n.htm#ADXD<wbr />B6371</a>
</div>


If you use ORACLE, you can read these articles:
https://blogs.oracle.com/jsondb/the-new-sqljson-query-operators-part1:-jsonvalue [https://blogs.oracle.com/jsondb/the-new-sqljson-query-operators-part1:-jsonvalue]
https://docs.oracle.com/database/121/ADXDB/json.htm#ADXDB6371 [https://docs.oracle.com/database/121/ADXDB/json.htm#ADXDB6371]

<div>
<div class="content wysiwyg-content">
How to use the decode command for Json values in SQL
</div>
</div>


How to use the decode command for Json values in SQL

Oracle is an object-relational database management system. It supports a large number of languages and application development frameworks. Its primary languages are SQL, PL/SQL and Java, but it also includes support for C and C++. Oracle also has its own enterprise modules and application server software.

Oracle Database

JavaScript Object Notation, or JSON, is human-readable text used when transmitting data objects consisting of attribute:value pairs between a server and a web application as an alternative to XML. JSON, while it is originally derived from JavaScript, is a language-independent data format. Code for parsing and generating JSON data is available in many programming languages.

JSON

SQL (Structured Query Language) is designed to be used in conjunction with relational database products as of a means of working with sets of data. SQL consists of data definition, data manipulation, and procedural elements. Its scope includes data insert, query, update and delete, schema creation and modification, and data access control.