How to use the decode command for Json values in SQL

How to use the decode command for Json values in SQL
venkatesh SarivisettySenior Software EngineerAsked:
Who is Participating?
 
venkatesh SarivisettyConnect With a Mentor Senior Software EngineerAuthor Commented:
Misha, thanks for your link
But my question here is like

how we can pull/get the necessary value from the json_object , for example in json column I have a  code called 12345, I need to get that data and prepare a column to display..

select json_value(col_name,'$.tab')        = 12345 as 12345?? will it works??? or any other ways
0
 
QlemoBatchelor, Developer and EE Topic AdvisorCommented:
Which database engine? Above is about MS SQL 2016/Azure.

*** Topic added ***
0
Get your problem seen by more experts

Be seen. Boost your question’s priority for more expert views and faster solutions

 
venkatesh SarivisettySenior Software EngineerAuthor Commented:
oracle sql
0
 
venkatesh SarivisettySenior Software EngineerAuthor Commented:
I need any suggestions on how to use the json value in the select statement. Please advise
0
 
venkatesh SarivisettySenior Software EngineerAuthor Commented:
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.
0
 
venkatesh SarivisettySenior Software EngineerAuthor Commented:
Finished from my side.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.