Identify the column which having JSON data in Oracle

For finding the JSON data in the User or Schema of Oracle

SELECT table_name,
       column_name,
       format,
       data_type
FROM   user_json_columns;

Find the JSON data in the User having permission on another schema in Oracle

SELECT table_name,
       column_name,
       format,
       data_type
FROM   all_json_columns;

Find the JSON data column value in all tables of the database in Oracle

SELECT table_name,
       column_name,
       format,
       data_type
FROM   dba_json_columns;