SELECT
    TABLE_NAME,
    COLUMN_NAME,
    CASE DATA_TYPE
      WHEN 'NUMBER' THEN DATA_TYPE || '(' || DATA_PRECISION || ',' || DATA_SCALE || ')'
      WHEN 'DATE' THEN DATA_TYPE
      WHEN 'VARCHAR2' THEN DATA_TYPE || '(' || DATA_LENGTH || ')'
      ELSE DATA_TYPE
    END
    DATA_TYPE, NULLABLE, DATA_DEFAULT, COLUMN_ID FROM ALL_TAB_COLUMNS
  WHERE OWNER='MPOWN'
  ;
  select * from ALL_TAB_COLUMNS
  where rownum =1 ;