SELECT  ALL_TAB_COLUMNS.TABLE_NAME,
        ALL_TAB_COLUMNS.COLUMN_NAME,
        ALL_TAB_COLUMNS.DATA_TYPE,
        ALL_TAB_COLUMNS.DATA_LENGTH,
        ALL_TAB_COLUMNS.DATA_PRECISION,
        ALL_TAB_COLUMNS.NULLABLE,
        ALL_TAB_COLUMNS.DATA_DEFAULT
FROM ALL_TAB_COLUMNS 
WHERE OWNER ='<SCHEMA>'  -- XL[}
  AND TABLE_NAME = '<TABLE>'

  AND TABLE_NAME IN (SELECT OBJECT_NAME 
                     FROM ALL_OBJECTS 
                    WHERE OWNER='<SCHEMA>'  -- XL[}
                      AND OBJECT_TYPE='TABLE' )  -- e[uŒ

