select a.column_name,a.data_type,a.data_length,a.nullable,a.data_default
from all_tab_cols a
where a.table_name='CUSTOMER' and a.owner='CMS_CUSTOMER'

------------------------

The above query runs fine on SQL * plus but on PL/SQL developer, the long datatype is being shown as .

Why is this so? And how can I display Long as text in any 3rd party front end?

Thanx