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
(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