Connected to Oracle Database 11g Enterprise Edition Release  11 . 1 . 0 . 7 . 0  
Connected as xxx
 
SQL> select c.COLUMN_NAME, c.data_type, c.data_length from all_tab_columns c
   2    where c.OWNER = 'APEX_030200' and c.table_name = 'APEX_APPLICATION_PAGE_REGIONS'
   3      and c.COLUMN_NAME in ('REGION_HEADER_TEXT', 'REGION_FOOTER_TEXT')
   4   ;
 
COLUMN_NAME                    DATA_TYPE                                                                        DATA_LENGTH
------------------------------ -------------------------------------------------------------------------------- -----------
REGION_HEADER_TEXT             VARCHAR2                                                                                 4000 
REGION_FOOTER_TEXT             VARCHAR2                                                                                 4000 
 
SQL>