title: how to read a excel file and insert data into oracle table
body: <p>i am using oracle 11g.how to read a excel file and insert data into oracle table using plsql and oracle forms.i am new to to his topic.<code>enter code here</code></p>
  
  <p>i tried <code>https://sites.google.com/site/craigsoraclestuff/oracle-forms-webutil/read-excel-into-forms</code></p>
  
  <p>i need simple correct answer.</p>
  
  <p>how to inser this part to the program  :</p>
  
  <pre><code>v_fName := WebUtil_File.File_Open_Dialog(
                    directory_name =&gt; 'C:\'
                    ,File_Filter =&gt; null
                    ,Title =&gt; 'Select Client filename to Open.'
              );
  </code></pre>
  
  <p>how to get cell value to a variable.i don't see it with this example.i have only one excel sheet.no need to check number of sheets.don't know how to customize all these things.</p>
  
  <p>i need data from 4th column,5th column,5th column   and from 5th row i wat to match column 5th with another table and not matches assign flag variable "N" and if matches then flag variable "y" fro each row.</p>