Convert values from LONG to CLOB using dbms_metadata_util.long2clob in SQL queries

Oracle: 12.2.0.1.0

Today I’ll show you a small simple function to convert values from LONG to CLOB in SQL queries.
I’ve seen many articles where authors create their convert fuctions or create a table and insert the LONG value via INSERT INTO SELECT statement.
Oracle has also made its own, so we don’t need to create our own:)
Continue reading “Convert values from LONG to CLOB using dbms_metadata_util.long2clob in SQL queries”