Convert rows from a SQL Query or Table to JSON format

Thanks for sharing.

How can we get the json format of concat 3 column and rest 2 columns will remain same as table columm. If a result set is returning 5 columns name, age, add1,add2,add3 so i want out as name, age and Json format of address column containing all add columns

What would you do to produce a json with array of array format? e.g: [[285, 'Syed', 'E', 'Abbas'], [293, 'Catherine', 'R', 'Abel'], ..]

when i use this kind of query in my node api i am getting stringified json response. But i want parsed json data. is there any way to get parsed json response from sql select statement?

Thanks for this video sir, I appreciate.

How to do the same in PLSQL Developer or Oracle SQL Developer. what keyword is used for converting records into JSON format

What would you do if there are many records being generated? I am coming up with the result output being broken because there are too many records. Is there a restriction in the resultset count when using JSON as an output for SQL?