Oracle Developer's Share

SELECT *
FROM   all_objects
WHERE  1 = 1
AND    object_name LIKE '%TABLE_NAME%'
AND    object_type = 'TABLE'
--AND    ownber = ''
AND    status = 'VALID'
--AND    created >= TO_DATE('20180101', 'YYYYMMDD')
--AND    last_ddl_time >= TO_DATE('20180101', 'YYYYMMDD')

SELECT *
FROM   all_tables
WHERE  1 = 1
AND    owner = ''
AND    table_name = 'TABLE_NAME'
AND    tablespace_name = 'FND';

SELECT   *
FROM     all_tab_columns
WHERE    1 = 1
AND      table_name = '%TABLE_NAME%'
AND      column_name = '%COLUMN_NAME%'
ORDER BY column_id;