-
Notifications
You must be signed in to change notification settings - Fork 0
/
Copy path문서.rtf
95 lines (95 loc) · 6.6 KB
/
문서.rtf
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
{\rtf1\ansi\ansicpg949\deff0\nouicompat\deflang1033\deflangfe1042{\fonttbl{\f0\fnil\fcharset129 \'b8\'bc\'c0\'ba \'b0\'ed\'b5\'f1;}}
{\*\generator Riched20 10.0.19041}\viewkind4\uc1
\pard\sa200\sl276\slmult1\f0\fs20\lang18 lsnrctl service\par
\par
create tablespace test\par
datafile 'c:\\oracle\\oradata\\testdb\\test01.dbf' size 100m\par
autoextend on ;\par
\par
create user test identified by test\par
default tablespace test\par
temporary tablespace temp\par
quota unlimited on test\par
quota unlimited on users;\par
\par
conn test/test\par
\par
CREATE TABLE books (\par
book_id NUMBER PRIMARY KEY,\par
title VARCHAR2(100) NOT NULL,\par
author VARCHAR2(100) NOT NULL,\par
publication_date DATE,\par
genre VARCHAR2(100)\par
)\par
tablespace test;\par
\par
CREATE TABLE members (\par
member_id NUMBER PRIMARY KEY,\par
name VARCHAR2(100) NOT NULL,\par
age NUMBER NOT NULL,\par
gender VARCHAR2(100) NOT NULL,\par
email VARCHAR2(100) NOT NULL,\par
phone_number VARCHAR2(100) NOT NULL\par
)\par
tablespace test;\par
\par
CREATE TABLE rentals (\par
rental_id NUMBER PRIMARY KEY,\par
book_id NUMBER NOT NULL,\par
member_id NUMBER NOT NULL,\par
rental_date DATE,\par
return_date DATE,\par
FOREIGN KEY (book_id) REFERENCES books(book_id),\par
FOREIGN KEY (member_id) REFERENCES members(member_id)\par
)\par
tablespace test;\par
\par
INSERT INTO books VALUES (1, 'The Great Gatsby', 'F. Scott Fitzgerald', TO_DATE('2022-01-01', 'YYYY-MM-DD'), 'Fiction');\par
INSERT INTO books VALUES (2, 'To Kill a Mockingbird', 'Harper Lee', TO_DATE('2022-02-15', 'YYYY-MM-DD'), 'Fiction');\par
INSERT INTO books VALUES (3, '1984', 'George Orwell', TO_DATE('2022-03-10', 'YYYY-MM-DD'), 'Dystopian Fiction');\par
INSERT INTO books VALUES (4, 'Pride and Prejudice', 'Jane Austen', TO_DATE('2022-04-05', 'YYYY-MM-DD'), 'Romance');\par
INSERT INTO books VALUES (5, 'The Hobbit', 'J.R.R. Tolkien', TO_DATE('2022-05-20', 'YYYY-MM-DD'), 'Fantasy');\par
INSERT INTO books VALUES (6, 'Harry Potter and the Sorcerer''s Stone', 'J.K. Rowling', TO_DATE('2022-06-15', 'YYYY-MM-DD'), 'Fantasy');\par
INSERT INTO books VALUES (7, 'The Catcher in the Rye', 'J.D. Salinger', TO_DATE('2022-07-01', 'YYYY-MM-DD'), 'Fiction');\par
INSERT INTO books VALUES (8, 'The Hunger Games', 'Suzanne Collins', TO_DATE('2022-08-10', 'YYYY-MM-DD'), 'Science Fiction');\par
INSERT INTO books VALUES (9, 'The Da Vinci Code', 'Dan Brown', TO_DATE('2022-09-25', 'YYYY-MM-DD'), 'Mystery');\par
INSERT INTO books VALUES (10, 'The Lord of the Rings', 'J.R.R. Tolkien', TO_DATE('2022-10-15', 'YYYY-MM-DD'), 'Fantasy');\par
INSERT INTO books VALUES (11, 'Gone with the Wind', 'Margaret Mitchell', TO_DATE('2022-11-05', 'YYYY-MM-DD'), 'Historical Fiction');\par
INSERT INTO books VALUES (12, 'The Shining', 'Stephen King', TO_DATE('2022-12-01', 'YYYY-MM-DD'), 'Horror');\par
INSERT INTO books VALUES (13, 'The Chronicles of Narnia', 'C.S. Lewis', TO_DATE('2023-01-10', 'YYYY-MM-DD'), 'Fantasy');\par
INSERT INTO books VALUES (14, 'Moby-Dick', 'Herman Melville', TO_DATE('2023-02-20', 'YYYY-MM-DD'), 'Adventure');\par
INSERT INTO books VALUES (15, 'Brave New World', 'Aldous Huxley', TO_DATE('2023-03-15', 'YYYY-MM-DD'), 'Dystopian Fiction');\par
\par
INSERT INTO members VALUES (101,'John Doe',25,'Male','[email protected]','123-4563-7890');\par
INSERT INTO members VALUES (102, 'Jane Smith', 30, 'Female', '[email protected]', '987-6534-3210');\par
INSERT INTO members VALUES (103, 'Robert Johnson', 35, 'Male', '[email protected]', '555-1223-4567');\par
INSERT INTO members VALUES (104, 'Emily White', 28, 'Female', '[email protected]', '789-6754-1230');\par
INSERT INTO members VALUES (105, 'Michael Davis', 22, 'Male', '[email protected]', '456-7819-0123');\par
INSERT INTO members VALUES (106, 'Amanda Brown', 27, 'Female', '[email protected]', '321-9887-6540');\par
INSERT INTO members VALUES (107, 'William Taylor', 32, 'Male', '[email protected]', '789-1232-4560');\par
INSERT INTO members VALUES (108, 'Olivia Miller', 26, 'Female', '[email protected]', '654-3321-0987');\par
INSERT INTO members VALUES (109, 'Daniel Wilson', 29, 'Male', '[email protected]', '012-3545-6789');\par
INSERT INTO members VALUES (110, 'Sophia Moore', 31, 'Female', '[email protected]', '987-0122-3456');\par
INSERT INTO members VALUES (111, 'Matthew Harris', 24, 'Male', '[email protected]', '234-5667-8901');\par
INSERT INTO members VALUES (112, 'Emma Anderson', 33, 'Female', '[email protected]', '456-7789-0123');\par
INSERT INTO members VALUES (113, 'Christopher Lee', 28, 'Male', '[email protected]', '789-0122-3456');\par
INSERT INTO members VALUES (114, 'Isabella Clark', 30, 'Female', '[email protected]', '012-3485-6789');\par
INSERT INTO members VALUES (115, 'Andrew Lewis', 27, 'Male', '[email protected]', '234-5674-8901');\par
\par
INSERT INTO rentals VALUES (10001, 1, 101, TO_DATE('2022-03-01', 'YYYY-MM-DD'), TO_DATE('2022-03-15', 'YYYY-MM-DD'));\par
INSERT INTO rentals VALUES (10002, 2, 102, TO_DATE('2022-04-10', 'YYYY-MM-DD'), TO_DATE('2022-05-01', 'YYYY-MM-DD'));\par
INSERT INTO rentals VALUES (10003, 3, 103, TO_DATE('2022-05-20', 'YYYY-MM-DD'), TO_DATE('2022-06-10', 'YYYY-MM-DD'));\par
INSERT INTO rentals VALUES (10004, 4, 104, TO_DATE('2022-06-15', 'YYYY-MM-DD'), TO_DATE('2022-07-01', 'YYYY-MM-DD'));\par
INSERT INTO rentals VALUES (10005, 5, 105, TO_DATE('2022-07-10', 'YYYY-MM-DD'), TO_DATE('2022-08-01', 'YYYY-MM-DD'));\par
INSERT INTO rentals VALUES (10006, 6, 106, TO_DATE('2022-08-20', 'YYYY-MM-DD'), TO_DATE('2022-09-10', 'YYYY-MM-DD'));\par
INSERT INTO rentals VALUES (10007, 7, 107, TO_DATE('2022-09-25', 'YYYY-MM-DD'), TO_DATE('2022-10-15', 'YYYY-MM-DD'));\par
INSERT INTO rentals VALUES (10008, 8, 108, TO_DATE('2022-10-30', 'YYYY-MM-DD'), TO_DATE('2022-11-15', 'YYYY-MM-DD'));\par
INSERT INTO rentals VALUES (10009, 9, 109, TO_DATE('2022-11-20', 'YYYY-MM-DD'), TO_DATE('2022-12-01', 'YYYY-MM-DD'));\par
INSERT INTO rentals VALUES (10010, 10, 110, TO_DATE('2022-12-10', 'YYYY-MM-DD'), TO_DATE('2022-12-25', 'YYYY-MM-DD'));\par
INSERT INTO rentals VALUES (10011, 11, 111, TO_DATE('2023-01-01', 'YYYY-MM-DD'), TO_DATE('2023-01-15', 'YYYY-MM-DD'));\par
INSERT INTO rentals VALUES (10012, 12, 112, TO_DATE('2023-02-01', 'YYYY-MM-DD'), TO_DATE('2023-02-15', 'YYYY-MM-DD'));\par
INSERT INTO rentals VALUES (10013, 13, 113, TO_DATE('2023-02-20', 'YYYY-MM-DD'), TO_DATE('2023-03-10', 'YYYY-MM-DD'));\par
INSERT INTO rentals VALUES (10014, 14, 114, TO_DATE('2023-03-15', 'YYYY-MM-DD'), TO_DATE('2023-04-01', 'YYYY-MM-DD'));\par
INSERT INTO rentals VALUES (10015, 15, 115, TO_DATE('2023-04-10', 'YYYY-MM-DD'), TO_DATE('2023-04-25', 'YYYY-MM-DD'));\par
}