-- Find JSON data type (enhanced in 19c) SELECT owner, table_name, column_name FROM dba_tab_columns WHERE data_type = 'JSON';
In the world of Oracle Database administration, data pumping (using Data Pump – expdp and impdp ) is the gold standard for moving data and metadata between databases. However, as organizations upgrade their systems, they often encounter compatibility issues when moving data from a newer database to an older one. -- Find JSON data type (enhanced in 19c)