2 Replies Latest reply: Apr 1, 2014 1:50 AM by vikramrathour RSS

    Export data from multiple tables

    vikramrathour

      Hi,

       

      I am using the Data Export utility in SQL Developer 4.0.1. There is an option to choose a list of tables that I want to include, however in my case I can get the list of tables by running a query against USER_TABLES and applying some NOT LIKE filters. How do i pass this list to the export utility.

       

      Is there a way to do this.

       

      e.g.

       

      SELECT table_name 
      from user_tables
      WHERE NOT (table_name LIKE 'DOD%' OR table_name LIKE 'DAY%' OR table_name LIKE '%_HIST');
      

       

      Whatever is the result I get is the list of tables I need to export.

       

      Regards,

      Vikram R