[ Database ] 테이블 생성

 

(참고) 아래는 다른 글에서 사용될 데이터베이스다.

 

 - product 테이블 생성

CREATE TABLE product (
    product_id NUMBER PRIMARY KEY, -- Product ID, automatically assigned using a sequence
    product_name VARCHAR2(50) NOT NULL, -- Name of the product
    product_category VARCHAR2(30) NOT NULL, -- Category of the product
    product_release_date DATE NOT NULL, -- Release date of the product
    product_price NUMBER DEFAULT 0 NOT NULL CHECK (product_price >= 0) -- Price of the product in local currency
);

CREATE SEQUENCE product_seq;

 

 - 더미 데이터 삽입

-- Inserting dummy data into the product table
INSERT INTO product (product_id, product_name, product_category, product_release_date, product_price)
VALUES (product_seq.NEXTVAL, 'Laptop XYZ', 'Electronics', TO_DATE('2024-01-20', 'YYYY-MM-DD'), 1200);

INSERT INTO product (product_id, product_name, product_category, product_release_date, product_price)
VALUES (product_seq.NEXTVAL, 'Smartphone ABC', 'Electronics', TO_DATE('2024-01-21', 'YYYY-MM-DD'), 800);

INSERT INTO product (product_id, product_name, product_category, product_release_date, product_price)
VALUES (product_seq.NEXTVAL, 'Desk Chair', 'Furniture', TO_DATE('2024-01-22', 'YYYY-MM-DD'), 100);

INSERT INTO product (product_id, product_name, product_category, product_release_date, product_price)
VALUES (product_seq.NEXTVAL, 'Coffee Maker', 'Appliances', TO_DATE('2024-01-23', 'YYYY-MM-DD'), 50);

INSERT INTO product (product_id, product_name, product_category, product_release_date, product_price)
VALUES (product_seq.NEXTVAL, 'Running Shoes', 'Apparel', TO_DATE('2024-01-24', 'YYYY-MM-DD'), 80);

INSERT INTO product (product_id, product_name, product_category, product_release_date, product_price)
VALUES (product_seq.NEXTVAL, 'Adventure Book', 'Books', TO_DATE('2024-01-25', 'YYYY-MM-DD'), 20);

SELECT * FROM product;

결과 확인

 

 

 

 

개인 공부 기록용입니다:)