title: Understanding Oracle Apex_Application.G_Fnn and how to use it
body: <p>I am quite confused with how Oracle apex_application.gfnn works and whether it only works for standard SQL reports in Oracle ApEx or only with SQL (Updateable reports, i.e. tabular forms).</p>
  
  <p>Basically I am trying to achieve the following using this sample SQL, which is just a Standard SQL Report but I'm unsure if what I am trying to achieve is possible with this type or report, i.e.:</p>
  
  <pre><code>select id,
         name,
         telephone,
         apex_item.checkbox2(10,id) as "Tick when Contacted",
         apex_item.text(20,my_date) as "Date Contacted",
         apex_item.textarea(30,my_comment,5,80) as "Comment"
  from   my_table
  </code></pre>
  
  <p>Based on the above SQL, assume this SQL query returns 10 rows. Now using checkbox as my driving id, I tick the checkbox of all odd records/rows, i.e. rows 1,3,5,7,9 and for each of these rows, I also enter a date value (f20) together with a comment (f30)</p>
  
  <p>Keeping this in mind, I then want to created a page process that is called when the user presses the "Save" button that will iterate through these checked rows and store for each record, my date and my comment but only for the rows that I have selected.</p>
  
  <p>So based on the above, I would expect to have 5 news rows in my table with the following columns:</p>
  
  <pre><code>ID      MY_DATE      MY_COMMENT
  1       26/08/2012   Comment A
  3       27/08/2012   Comment B
  5       28/08/2012   Comment C
  7       29/08/2012   Comment D
  9       30/08/2012   Comment E
  </code></pre>
  
  <p>Unfortunately I am unsure how to achieve this using <code>apex_application.G_F10.COUNT</code>.</p>
  
  <p>I want to be able to access the content of each of these array elements (f20) and f(f30) for each row that I have ticked the checkbox with.</p>
  
  <p>Is this possible or have I misunderstood how apex_application.G_Fnn works? If this is not possible, how I can achieve this? Do I need a tabular report?</p>