Get Oracle Partition High Values as VARCHAR2 types instead of LONG in Oracle 19c and earlier

Here’s a little PL/SQL function create_partition_high_value_func.sql that allows you to write SQL queries against data dictionary for partition maintenance automation and examination operations, by converting the cumbersome LONG-datatype to VARCHAR2 on the fly. This approach works also on Oracle 19c and earlier versions. It runs a nested SQL query inside PL/SQL for every (owner, table, partition_name) tuple that your SQL passes into the function. This is normally not a good practice for perfo...