Pages

As said earlier create a similar table named as Customer

CREATE TABLE CUSTOMER
(CNUM NUMBER(4) PRIMARY KEY,
 CNAME VARCHAR2(20),
CITY VARCHAR2(25),
RATING NUMBER(3),
SNUM NUMBER(3) CONSTRAINT SNUM_FKEY REFERENCES SALESMAN);

And insert the following values into Customer Table.


CNUM CNAME         CITY     RATING     SNUM
--------------------------------------------------------  
    2001 HARDIK           LONDON    100      1001
    2002 GITA               ROME         200      1003
    2003 LAXIT           SURAT        200      1002
    2004 GOVIND       BOMBAY    300     1002
    2005 CHANDU      LONDON    100      1001
    2006 CHAMPAK   SURAT        300     1007
    2007 PRATIK        ROME          100      1004

No comments:

Post a Comment