title: How extract table names from PL/SQL package body file?
body: <p>I need to get the table names queried in a pl/sql package file.</p>
  
  <p>I know that there is an option for this in Notepad++ by regex but I don't know what regex to apply for get the table names (I understand that must be some regex to take the keyword "FROM" and get the next string after space, I think so). </p>
  
  <p>For the next example code:</p>
  
  <pre><code>CREATE OR REPLACE PACKAGE BODY pac_example AS
  
  FUNCTION f1 RETURN NUMBER IS
  BEGIN
    SELECT * FROM table1;
    RETURN 1;
  END f1;
  
  FUNCTION f2 RETURN NUMBER IS
  BEGIN
    SELECT * FROM table2;
    RETURN 1;
  END f2;
  
  END pac_example;
  </code></pre>
  
  <p>And <strong>I expect replace all and get the file with only its table names</strong>:</p>
  
  <pre><code>table1
  table2
  </code></pre>