DB/insertTables.sql at main · razshely/DB · GitHub

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
insert into MOVIES(TITLE,
                   LENGTH,
                   UPLOAD_DATE,
                   RANK)
                   VALUES ('rush hour', 2,to_date('11-11-2008','dd-mm-yyyy'),7.5);


insert into MOVIES(TITLE,
                   LENGTH,
                   UPLOAD_DATE,
                   RANK)
                   VALUES ('the Shawshank', 3,to_date('26-10-2009','dd-mm-yyyy'),9.5);


insert into MOVIES(TITLE,
                   LENGTH,
                   UPLOAD_DATE,
                   RANK)
                   VALUES ('Pulp Fiction', 7,to_date('11-11-2009','dd-mm-yyyy'),5.5);


insert into MOVIES(TITLE,
                   LENGTH,
                   UPLOAD_DATE,
                   RANK)
                   VALUES ('Inception', 2,to_date('11-05-2018','dd-mm-yyyy'),3.5);

insert into MOVIES(TITLE,
                   LENGTH,
                   UPLOAD_DATE,
                   RANK)
                   VALUES ('The Dark Knight', 5,to_date('11-05-2017','dd-mm-yyyy'),2);

insert into MOVIES(TITLE,
                   LENGTH,
                   UPLOAD_DATE,
                   RANK)
                   VALUES ('Fight Club', 3,to_date('11-08-2018','dd-mm-yyyy'),3);

insert into MOVIES(TITLE,
                   LENGTH,
                   UPLOAD_DATE,
                   RANK)
                   VALUES ('Rear Window', 2,to_date('12-05-2018','dd-mm-yyyy'),4);

insert into MOVIES(TITLE,
                   LENGTH,
                   UPLOAD_DATE,
                   RANK)
                   VALUES ('Psycho', 1,to_date('11-05-2019','dd-mm-yyyy'),9);

insert into MOVIES(TITLE,
                   LENGTH,
                   UPLOAD_DATE,
                   RANK)
                   VALUES ('se7en', 2,to_date('11-02-2018','dd-mm-yyyy'),8);

insert into Worker(Id,
                   Name,
                   Birthday,
                   Petname)
                   values(123,'jon',to_date('11-02-1985','dd-mm-yyyy'),'bb')


insert into Worker(Id,
                   Name,
                   Birthday,
                   Petname)
                   values(124,'ben',to_date('11-05-1995','dd-mm-yyyy'),'KIKI')


insert into Worker(Id,
                   Name,
                   Birthday,
                   Petname)
                   values(125,'pet',to_date('11-02-1982','dd-mm-yyyy'),'poo')

insert into Stylist(tools)
                   VALUES ('scissors');

insert into Stylist(tools)
                   VALUES ('hairbrush');

insert into Stylist(tools)
                   VALUES ('pedikur');

insert into genre(gener_ID,descrption,)
                   VALUES (235648,'horor');

insert into genre(gener_ID,descrption,)
                   VALUES (235646,'funny');

insert into genre(gener_ID,descrption,)
                   VALUES (235647,'sad');