-- usersテーブルの作成
CREATE TABLE users (
    ID       NUMBER PRIMARY KEY,
    name     VARCHAR2(40),
    email    VARCHAR2(80),
    birthday DATE
);

-- usersテーブルにデータを挿入
INSERT INTO users (ID, name, email, birthday) VALUES (1,  'Alice',   'alice@example.com',   TO_DATE('1990-01-01', 'YYYY-MM-DD'));
INSERT INTO users (ID, name, email, birthday) VALUES (2,  'Bob',     'bob@example.com',     TO_DATE('1985-02-15', 'YYYY-MM-DD'));
INSERT INTO users (ID, name, email, birthday) VALUES (3,  'Charlie', 'charlie@example.com', TO_DATE('1980-03-20', 'YYYY-MM-DD'));
INSERT INTO users (ID, name, email, birthday) VALUES (4,  'David',   'david@example.com',   TO_DATE('1992-04-10', 'YYYY-MM-DD'));
INSERT INTO users (ID, name, email, birthday) VALUES (5,  'Eva',     'eva@example.com',     TO_DATE('1993-05-05', 'YYYY-MM-DD'));
INSERT INTO users (ID, name, email, birthday) VALUES (6,  'Frank',   'frank@example.com',   TO_DATE('1988-06-15', 'YYYY-MM-DD'));
INSERT INTO users (ID, name, email, birthday) VALUES (7,  'Grace',   'grace@example.com',   TO_DATE('1995-07-20', 'YYYY-MM-DD'));
INSERT INTO users (ID, name, email, birthday) VALUES (8,  'Hannah',  'hannah@example.com',  TO_DATE('1983-08-25', 'YYYY-MM-DD'));
INSERT INTO users (ID, name, email, birthday) VALUES (9,  'Ivy',     'ivy@example.com',     TO_DATE('1991-09-10', 'YYYY-MM-DD'));
INSERT INTO users (ID, name, email, birthday) VALUES (10, 'Jack',    'jack@example.com',    TO_DATE('1987-10-30', 'YYYY-MM-DD'));

COMMIT;

-- usersテーブルを表示
set line 200
SELECT * FROM users;