Check if table is compressed using Oracle.

You can use the following SQL statement in Oracle database to check if a table is compressed:

SELECT table_name, compression FROM all_tables WHERE table_name = 'your_table_name';

Replace “your_table_name” with the name of the table you want to query.

If the “compression” column in the query result shows “ENABLED”, then the table is compressed; if it shows “DISABLED”, then the table is not compressed.