Oracle PL/SQL/System Tables Views/dba external tables

Query dba_external_tables

   <source lang="sql">

SQL> SQL> set verify off SQL> set linesize 81 SQL> set pagesize 9999 SQL> set feedback on SQL> SQL> select table_name, access_parameters parms

 2    from dba_external_tables
 3    where rownum < 50
 4   order by table_name
 5  /

no rows selected SQL> SQL> --

</source>