1 Reply Latest reply: Jul 28, 2005 4:12 PM by 252355 RSS

    using cursors or join

    441475
      i have four tables and i want to use the information from the four tables so what is the most eficient way , to create a view joining the four tables or to create a data block using oracle developer and use the post query trigger to retrieve the information from the others tables by using cursors or select into (my point is that by using post query the cursors is performed only on the records fetched from the database (10 records for example) and when you show more records by moving the scroll bar for example the post query then works but using the join between the tables means that oracle should evaluate all records at once which means taking more time)
      Thanks
        • 1. Re: using cursors or join
          252355
          As per your explanation and requirement, Best approach is create you VIEW with joing of four tables. Develope a form based on the VIEW which does not require to refresh or wait for data load time.

          VIEW can accomplish your requirement.

          JP
          ..