Tutorial for Designer/2000
and Developer/2000


Lesson 9

In this lesson you will learn how to create an end-user interface and add more functionality to the basic form that we created in Lesson 8. Specifically, this will involve:

List of Values (LOVs)

  1. In this form we are designing, we will create a List of Values for major, so that the user can select a major from the list. To do this, first we will have to create table called Major_List.

  2. To do this, go to SQL*Plus and type the following code at the SQL prompt

    SQL> CREATE TABLE MAJOR_LIST
    2 (MAJOR VARCHAR2(20));

  3. Now type in the following statement to insert more data into the Major_list table:

    SQL> INSERT INTO MAJOR_LIST VALUES ('Accounting');
    SQL> INSERT INTO MAJOR_LIST VALUES ('Info. Systems');
    SQL> INSERT INTO MAJOR_LIST VALUES ('Marketing');
    SQL> INSERT INTO MAJOR_LIST VALUES ('Finance');
    SQL> INSERT INTO MAJOR_LIST VALUES ('Decision Sciences');

  4. Now, type in Select * from Major_List to view your newly created table and its records. (See Figure 9.1)

    Figure 9.1

    Figure 9.1: Creating table Major_List in SQL*PLUS

  5. First, select LOV in the Object Navigator on Developer/2000 and click on the "+" sign on the toolbar to your left. (See Figure 9.2)

    Figure 9.2

    Figure 9.2: Creating a new LOV

  6. Immediately, the window for the new LOV will pop up. (See Figure 9.3)

    Figure 9.3

    Figure 9.3: The New LOV Window

  7. Type in the following Select statement in the window to connect the new LOV to the Major_List table that we created earlier and click OK. (See figure 9.4)

    Figure 9.4

    Figure 9.4: The New LOV Window with the select code

    select major into :studblock.major from major_list order by major;

  8. Once you click OK, you will come back to the Object navigator window. Now, name the LOV as MAJOR_LOV by double clicking the word LOV. (See Figure 9.5)

    Figure 9.5

    Figure 9.5: Changing the name of the LOV

  9. Now go back to the Canvas View by clicking on the small picture icon just beneath the word Canvases in the Object Navigator. (See Figure 9.6)

    Figure 9.6

    Figure 9.6: Returning to the Canvas view

  10. In the Canvas View, we will create a push button and position it right beside the Major data field. To create the push button, select the box like icon from the toolbox, click on it once and drop it beside the Major data field. (See Figure 9.7)

    Figure 9.7

    Figure 9.7: Creating a push button to place it beside the Major data field

  11. After the push button has been created, then right click on the button and select Property Palette from the list that pops up. (See Figure 9.8)

    Figure 9.8

    Figure 9.8: Selecting Property Palette for the Push Button

  12. Once you are in the Property Palette, remove the label, specify Iconic as Yes and in the icon Filename type Down. Click on the close button in the lower taskbar located on the upper right corner. (See Figure 9.9)

    Figure 9.9

    Figure 9.9: The Property Palette for the Push Button

  13. You will now return to Canvas View. Your Canvas will now look like Figure 9.10.

    Figure 9.10

    Figure 9.10: The Canvas View with the Push Button for the LOV

  14. Now back in the canvas, right click on push and this time select the PL/SQL Editor. (See Figure 9.11)

    Figure 9.11

    Figure 9.11: Selecting the PL/SQL Editor of the Iconic Button

On to page two

Page 1, Page 2, Page 3, Page 4 / Back to the tutorial index.


Main Page About the Book Student Resources Oracle Resources Instructor Resources Contact Us

1999 Prentice-Hall, Inc., A division of Pearson Education, Upper Saddle River, New Jersey 07458 Legal Statement
Comments should be directed to webmaster@prenhall.com