Hey everyone,I'm taking my first SQL class and trying to replicate the code in this picture. I'm wondering if the code is space-sensitive in certain areas
For example, in the very last line, does it matter if I have:CONSTRAINT ORDER_LINE_FK2 FOREIGN KEY (PRODUCT_ID) REFERENCES PRODUCT_T(PRODUCT_ID));
vs.CONSTRAINT ORDER_LINE_FK2 FOREIGN KEY (PRODUCT_ID) REFERENCES PRODUCT_T (PRODUCT_ID));
(where the second one has a space between PRODUCT_T and (PRODUCT_ID));Also, would anyone be able to run this code for me and tell me if it works, or would work? I don't have Oracle SQL on my computer.CREATE TABLE CUSTOMER_T (CUSTOMER_ID NUMBER(11,0)NOT NULL, CUSTOMER_NAME VARCHAR2(25)NOT NULL, CUSTOMER_ADDRESS VARCHAR2(30), CITY VARCHAR2(20), STATE VARCHAR2(2), POSTAL_CODE vARCHAR2(9),CONSTRAINT CUSTOMER_PK PRIMARY KEY (CUSTOMER_ID));CREATE TABLE ORDER_T (ORDER_ID NUMBER(11,0) NOT NULL, ORDER_DATE DATE DEFAULT SYSDATE, CUSTOMER_ID NUMBER(11,0),CONSTRAINT ORDER_PK PRIMARY KEY (ORDER_ID),CONSTRAINT ORDER_FK FOREIGN KEY (CUSTOMER_ID) REFERENCES CUSTOMER_T(CUSTOMER_ID));CREATE TABLE PRODUCT_T (PRODUCT_ID INTEGER NOT NULL, PRODUCT_DESCRIPTION VARCHAR2(50), PRODUCT_FINISH VARCHAR2(20) CHECK (PRODUCT_FINISH IN ('Cherry', 'Natural Ash', 'White Ash', 'Red Oak', 'Natural Oak', 'Walnut')), STANDARD_PRICE DECIMAL(6,2), PRODUCT_LINE_ID INTEGER,CONSTRAINT PRODUCT_PK PRIMARY KEY (PRODUCT_ID));CREATE TABLE ORDER_LINE_T (ORDER_ID NUMBER(11,0) NOT NULL, PRODUCT_ID NUMBER(11,0) NOT NULL, ORDERED_QUANTITY NUMBER(11,0),CONSTRAINT ORDER_LINE_PK PRIMARY KEY (ORDER_ID, PRODUCT_ID),CONSTRAINT ORDER_LINE_FK1 FOREIGN KEY(ORDER_ID) REFERENCES ORDER_T(ORDER_ID),CONSTRAINT ORDER_LINE_FK2 FOREIGN KEY (PRODUCT_ID) REFERENCES PRODUCT_T(PRODUCT_ID));Thanks so much.
Oracle SQL Simple Table Verification
Posted - 2012-02-27 : 20:36:27
