How to List Tables with Reorganisation Type

Hi All,

Please help with SQL query to list Tables (selected 'n' tables) with their reorg type (like Offline/Online) in SINGLE query.

Approach:

1.Take top 50 tables

2. If table has data type LONG or LONG RAW, table should be considered for OFFLINE reorganization and remaining tables for ONLINE reorg.

Help is much appreciated !

As of now, getting it done using separate queries and excel sorting.

Thanks

Ram