I have this project to do for a course in Oracle. We really spent no time at all on learning the programming as a result I am lost. I have already built and loaded the tables needed. I have also tried to construct the web interface with the appropriate buttons and input fields. Can anyone put me on the right track. I really need help with the programming. Here is the outline of what's needed for the project:

All projects will consist of four tables. The tables to be used for the project are contained at the bottom of this document. A sequence for generating the primary keys for each table are also included.

Primary Business Rule: A customer may place an order for only one item at a time. Each additional item to be purchased requires a new order number.

Data loading. Students will have insert their own made up data into the tables with a minimum of 10 rows in each table.

Main interface. The main interface must allow you to view all information from each of the three tables at the same time based on the ORDERS table. The following functionality must be supported in the main interface: 

    Next:      Meaning displaying the next set of results.
    Previous:    Meaning dispalying the previous set of results.
    Search:    Meaning a way to search both Table 1 and Table 2 to loc
+ate results and display them. (May require an additional interface.)
              Last:    Meaning displaying the very last set of results
+.
    First:    Meaning displaying the very first set of results.
    Update:    Meaning a way of updating changes to information in the
+ main interface.

[download]
Data to be displayed should be order number, customer name and id, address and phone number; supplier name, id and address; when the order was placed, when it was shipped, how it was shipped and terms of payment. It shoud also include the item that was purchased, the quantity of the item order, the description of the item and both its cost and price; the profit made on the order

PL/SQL requirements. You must use a single package to carry out all of the required functionality as described in the Main interface.

HTML requirements. Using Javascript or VBscript in your HTML pages will result in an immediate grade of F for your project. Functionality is more important, at least for this project, than the way the results are presented.

PERL requirements. At most only one PERL script should be used in order to satisfy all the requirements for the Main interface, however, if you want to use more than one, you may.

THANKS IN ADVANCE GUYS.

Edit by tye, title, preserve formatting

In reply to Help me with Oracle course work by illa23

Title:
Use:  <p> text here (a paragraph) </p>
and:  <code> code here </code>
to format your post, it's "PerlMonks-approved HTML":


  • Posts are HTML formatted. Put <p> </p> tags around your paragraphs. Put <code> </code> tags around your code and data!
  • Titles consisting of a single word are discouraged, and in most cases are disallowed outright.
  • Read Where should I post X? if you're not absolutely sure you're posting in the right place.
  • Please read these before you post! —
  • Posts may use any of the Perl Monks Approved HTML tags:
    a, abbr, b, big, blockquote, br, caption, center, col, colgroup, dd, del, details, div, dl, dt, em, font, h1, h2, h3, h4, h5, h6, hr, i, ins, li, ol, p, pre, readmore, small, span, spoiler, strike, strong, sub, summary, sup, table, tbody, td, tfoot, th, thead, tr, tt, u, ul, wbr
  • You may need to use entities for some characters, as follows. (Exception: Within code tags, you can put the characters literally.)
            For:     Use:
    & &amp;
    < &lt;
    > &gt;
    [ &#91;
    ] &#93;
  • Link using PerlMonks shortcuts! What shortcuts can I use for linking?
  • See Writeup Formatting Tips and other pages linked from there for more info.