Creating the Table

Perform the following steps to create and load the table:

1. Connect as the appropriate user.

   Connect as the myuser with CTXAPP role:

   CONNECT myuser;

2. Create your table.

   Set up an auction table to store your inventory:

   CREATE TABLE auction( item_id NUMBER, title VARCHAR2(100), category_id NUMBER, price NUMBER, bid_close DATE);

3. Populate your table.

   Populate the table with various items, each with an id, title, price and bid_date:

   INSERT INTO AUCTION VALUES(1, 'NIKON CAMERA', 1, 400, '24-OCT-2002'); INSERT INTO AUCTION VALUES(2, 'OLYMPUS CAMERA', 1, 300, '25-OCT-2002'); INSERT INTO AUCTION VALUES(3, 'PENTAX CAMERA', 1, 200, '26-OCT-2002'); INSERT INTO AUCTION VALUES(4, 'CANON CAMERA', 1, 250, '27-OCT-2002');