· 8 years ago · Jan 07, 2018, 05:54 PM
1-- Table: godziny_przyjec
2CREATE TABLE godziny_przyjec (
3 dzien_tygodnia VARCHAR2(20) CHECK( dzien_tygodnia IN ('Poniedzialek','Wtorek','Sroda','Czwartek','Piatek','Sobota','Niedziela') ) NOT NULL,
4 lekarz_id_lekarz number(10) NOT NULL,
5 Godziny_Od VARCHAR2(5) NOT NULL,
6 Godziny_Do VARCHAR2(5) NOT NULL,
7 CONSTRAINT godziny_przyjec_pk PRIMARY KEY (dzien_tygodnia)
8) ;
9
10
11
12INSERT INTO godziny_przyjec VALUES ('Poniedzialek', 132498, '08:00', '18:00');
13
14
15INSERT INTO godziny_przyjec VALUES ('Poniedzialek', 662102, '08:00', '13:00');
16INSERT INTO godziny_przyjec VALUES ('Poniedzialek', 698950, '08:00', '14:00');
17INSERT INTO godziny_przyjec VALUES ('Poniedzialek', 821019, '10:00', '16:00');
18INSERT INTO godziny_przyjec VALUES ('Poniedzialek', 875167, '10:00', '16:00');
19
20INSERT INTO godziny_przyjec VALUES ('Wtorek', 360840, '07:00', '22:00');
21
22
23INSERT INTO godziny_przyjec VALUES ('Wtorek', 666969, '08:00', '16:00');
24INSERT INTO godziny_przyjec VALUES ('Wtorek', 821019, '10:00', '16:00');
25INSERT INTO godziny_przyjec VALUES ('Wtorek', 875167, '11:00', '18:00');
26
27INSERT INTO godziny_przyjec VALUES ('Sroda', 132498, '08:00', '15:00');
28
29
30INSERT INTO godziny_przyjec VALUES ('Sroda', 662102, '13:00', '18:00');
31INSERT INTO godziny_przyjec VALUES ('Sroda', 821019, '10:00', '16:00');
32
33INSERT INTO godziny_przyjec VALUES ('Czwartek', 342144, '10:00', '17:00');
34
35
36INSERT INTO godziny_przyjec VALUES ('Czwartek', 554946, '08:00', '18:00');
37INSERT INTO godziny_przyjec VALUES ('Czwartek', 666969, '08:00', '17:00');
38INSERT INTO godziny_przyjec VALUES ('Czwartek', 698950, '14:00', '20:00');
39INSERT INTO godziny_przyjec VALUES ('Czwartek', 821019, '10:00', '16:00');
40
41INSERT INTO godziny_przyjec VALUES ('Piatek', 342144, '08:00', '15:00');
42
43
44INSERT INTO godziny_przyjec VALUES ('Piatek', 662102, '10:00', '18:00');
45INSERT INTO godziny_przyjec VALUES ('Piatek', 698950, '14:00', '20:00');
46INSERT INTO godziny_przyjec VALUES ('Piatek', 784250, '08:00', '17:00');
47INSERT INTO godziny_przyjec VALUES ('Piatek', 821019, '10:00', '16:00');
48
49INSERT INTO godziny_przyjec VALUES ('Sobota', 342144, '08:00', '13:00');
50
51
52INSERT INTO godziny_przyjec VALUES ('Sobota', 554946, '08:00', '15:00');
53
54
551 row inserted.
56
57
58Error starting at line : 2 in command -
59INSERT INTO godziny_przyjec VALUES ('Poniedzialek', 662102, '08:00', '13:00')
60Error report -
61SQL Error: ORA-00001: naruszono więzy unikatowe (X.GODZINY_PRZYJEC_PK)
6200001. 00000 - "unique constraint (%s.%s) violated"
63*Cause: An UPDATE or INSERT statement attempted to insert a duplicate key.
64 For Trusted Oracle configured in DBMS MAC mode, you may see
65 this message if a duplicate entry exists at a different level.
66*Action: Either remove the unique restriction or do not insert the key.
67
68Error starting at line : 3 in command -
69INSERT INTO godziny_przyjec VALUES ('Poniedzialek', 698950, '08:00', '14:00')
70Error report -
71SQL Error: ORA-00001: naruszono więzy unikatowe (X.GODZINY_PRZYJEC_PK)
7200001. 00000 - "unique constraint (%s.%s) violated"
73*Cause: An UPDATE or INSERT statement attempted to insert a duplicate key.
74 For Trusted Oracle configured in DBMS MAC mode, you may see
75 this message if a duplicate entry exists at a different level.
76*Action: Either remove the unique restriction or do not insert the key.
77
78Error starting at line : 4 in command -
79INSERT INTO godziny_przyjec VALUES ('Poniedzialek', 821019, '10:00', '16:00')
80Error report -
81SQL Error: ORA-00001: naruszono więzy unikatowe (X.GODZINY_PRZYJEC_PK)
8200001. 00000 - "unique constraint (%s.%s) violated"
83*Cause: An UPDATE or INSERT statement attempted to insert a duplicate key.
84 For Trusted Oracle configured in DBMS MAC mode, you may see
85 this message if a duplicate entry exists at a different level.
86*Action: Either remove the unique restriction or do not insert the key.
87
88Error starting at line : 5 in command -
89INSERT INTO godziny_przyjec VALUES ('Poniedzialek', 875167, '10:00', '16:00')
90Error report -
91SQL Error: ORA-00001: naruszono więzy unikatowe (X.GODZINY_PRZYJEC_PK)
9200001. 00000 - "unique constraint (%s.%s) violated"
93*Cause: An UPDATE or INSERT statement attempted to insert a duplicate key.
94 For Trusted Oracle configured in DBMS MAC mode, you may see
95 this message if a duplicate entry exists at a different level.
96*Action: Either remove the unique restriction or do not insert the key.
97
981 row inserted.
99
100
101Error starting at line : 7 in command -
102INSERT INTO godziny_przyjec VALUES ('Wtorek', 666969, '08:00', '16:00')
103Error report -
104SQL Error: ORA-00001: naruszono więzy unikatowe (X.GODZINY_PRZYJEC_PK)
10500001. 00000 - "unique constraint (%s.%s) violated"
106*Cause: An UPDATE or INSERT statement attempted to insert a duplicate key.
107 For Trusted Oracle configured in DBMS MAC mode, you may see
108 this message if a duplicate entry exists at a different level.
109*Action: Either remove the unique restriction or do not insert the key.
110
111Error starting at line : 8 in command -
112INSERT INTO godziny_przyjec VALUES ('Wtorek', 821019, '10:00', '16:00')
113Error report -
114SQL Error: ORA-00001: naruszono więzy unikatowe (X.GODZINY_PRZYJEC_PK)
11500001. 00000 - "unique constraint (%s.%s) violated"
116*Cause: An UPDATE or INSERT statement attempted to insert a duplicate key.
117 For Trusted Oracle configured in DBMS MAC mode, you may see
118 this message if a duplicate entry exists at a different level.
119*Action: Either remove the unique restriction or do not insert the key.
120
121Error starting at line : 9 in command -
122INSERT INTO godziny_przyjec VALUES ('Wtorek', 875167, '11:00', '18:00')
123Error report -
124SQL Error: ORA-00001: naruszono więzy unikatowe (X.GODZINY_PRZYJEC_PK)
12500001. 00000 - "unique constraint (%s.%s) violated"
126*Cause: An UPDATE or INSERT statement attempted to insert a duplicate key.
127 For Trusted Oracle configured in DBMS MAC mode, you may see
128 this message if a duplicate entry exists at a different level.
129*Action: Either remove the unique restriction or do not insert the key.
130
1311 row inserted.
132
133
134Error starting at line : 11 in command -
135INSERT INTO godziny_przyjec VALUES ('Sroda', 662102, '13:00', '18:00')
136Error report -
137SQL Error: ORA-00001: naruszono więzy unikatowe (X.GODZINY_PRZYJEC_PK)
13800001. 00000 - "unique constraint (%s.%s) violated"
139*Cause: An UPDATE or INSERT statement attempted to insert a duplicate key.
140 For Trusted Oracle configured in DBMS MAC mode, you may see
141 this message if a duplicate entry exists at a different level.
142*Action: Either remove the unique restriction or do not insert the key.
143
144Error starting at line : 12 in command -
145INSERT INTO godziny_przyjec VALUES ('Sroda', 821019, '10:00', '16:00')
146Error report -
147SQL Error: ORA-00001: naruszono więzy unikatowe (X.GODZINY_PRZYJEC_PK)
14800001. 00000 - "unique constraint (%s.%s) violated"
149*Cause: An UPDATE or INSERT statement attempted to insert a duplicate key.
150 For Trusted Oracle configured in DBMS MAC mode, you may see
151 this message if a duplicate entry exists at a different level.
152*Action: Either remove the unique restriction or do not insert the key.
153
1541 row inserted.
155
156
157Error starting at line : 14 in command -
158INSERT INTO godziny_przyjec VALUES ('Czwartek', 554946, '08:00', '18:00')
159Error report -
160SQL Error: ORA-00001: naruszono więzy unikatowe (X.GODZINY_PRZYJEC_PK)
16100001. 00000 - "unique constraint (%s.%s) violated"
162*Cause: An UPDATE or INSERT statement attempted to insert a duplicate key.
163 For Trusted Oracle configured in DBMS MAC mode, you may see
164 this message if a duplicate entry exists at a different level.
165*Action: Either remove the unique restriction or do not insert the key.
166Error starting at line : 15 in command -
167INSERT INTO godziny_przyjec VALUES ('Czwartek', 666969, '08:00', '17:00')
168Error report -
169SQL Error: ORA-00001: naruszono więzy unikatowe (X.GODZINY_PRZYJEC_PK)
17000001. 00000 - "unique constraint (%s.%s) violated"
171*Cause: An UPDATE or INSERT statement attempted to insert a duplicate key.
172 For Trusted Oracle configured in DBMS MAC mode, you may see
173 this message if a duplicate entry exists at a different level.
174*Action: Either remove the unique restriction or do not insert the key.
175
176Error starting at line : 16 in command -
177INSERT INTO godziny_przyjec VALUES ('Czwartek', 698950, '14:00', '20:00')
178Error report -
179SQL Error: ORA-00001: naruszono więzy unikatowe (X.GODZINY_PRZYJEC_PK)
18000001. 00000 - "unique constraint (%s.%s) violated"
181*Cause: An UPDATE or INSERT statement attempted to insert a duplicate key.
182 For Trusted Oracle configured in DBMS MAC mode, you may see
183 this message if a duplicate entry exists at a different level.
184*Action: Either remove the unique restriction or do not insert the key.
185
186Error starting at line : 17 in command -
187INSERT INTO godziny_przyjec VALUES ('Czwartek', 821019, '10:00', '16:00')
188Error report -
189SQL Error: ORA-00001: naruszono więzy unikatowe (X.GODZINY_PRZYJEC_PK)
19000001. 00000 - "unique constraint (%s.%s) violated"
191*Cause: An UPDATE or INSERT statement attempted to insert a duplicate key.
192 For Trusted Oracle configured in DBMS MAC mode, you may see
193 this message if a duplicate entry exists at a different level.
194*Action: Either remove the unique restriction or do not insert the key.
195
1961 row inserted.
197
198
199Error starting at line : 19 in command -
200INSERT INTO godziny_przyjec VALUES ('Piatek', 662102, '10:00', '18:00')
201Error report -
202SQL Error: ORA-00001: naruszono więzy unikatowe (X.GODZINY_PRZYJEC_PK)
20300001. 00000 - "unique constraint (%s.%s) violated"
204*Cause: An UPDATE or INSERT statement attempted to insert a duplicate key.
205 For Trusted Oracle configured in DBMS MAC mode, you may see
206 this message if a duplicate entry exists at a different level.
207*Action: Either remove the unique restriction or do not insert the key.
208
209Error starting at line : 20 in command -
210INSERT INTO godziny_przyjec VALUES ('Piatek', 698950, '14:00', '20:00')
211Error report -
212SQL Error: ORA-00001: naruszono więzy unikatowe (X.GODZINY_PRZYJEC_PK)
21300001. 00000 - "unique constraint (%s.%s) violated"
214*Cause: An UPDATE or INSERT statement attempted to insert a duplicate key.
215 For Trusted Oracle configured in DBMS MAC mode, you may see
216 this message if a duplicate entry exists at a different level.
217*Action: Either remove the unique restriction or do not insert the key.
218
219Error starting at line : 21 in command -
220INSERT INTO godziny_przyjec VALUES ('Piatek', 784250, '08:00', '17:00')
221Error report -
222SQL Error: ORA-00001: naruszono więzy unikatowe (X.GODZINY_PRZYJEC_PK)
22300001. 00000 - "unique constraint (%s.%s) violated"
224*Cause: An UPDATE or INSERT statement attempted to insert a duplicate key.
225 For Trusted Oracle configured in DBMS MAC mode, you may see
226 this message if a duplicate entry exists at a different level.
227*Action: Either remove the unique restriction or do not insert the key.
228
229Error starting at line : 22 in command -
230INSERT INTO godziny_przyjec VALUES ('Piatek', 821019, '10:00', '16:00')
231Error report -
232SQL Error: ORA-00001: naruszono więzy unikatowe (X.GODZINY_PRZYJEC_PK)
23300001. 00000 - "unique constraint (%s.%s) violated"
234*Cause: An UPDATE or INSERT statement attempted to insert a duplicate key.
235 For Trusted Oracle configured in DBMS MAC mode, you may see
236 this message if a duplicate entry exists at a different level.
237*Action: Either remove the unique restriction or do not insert the key.
238
2391 row inserted.
240
241
242Error starting at line : 24 in command -
243INSERT INTO godziny_przyjec VALUES ('Sobota', 554946, '08:00', '15:00')
244Error report -
245SQL Error: ORA-00001: naruszono więzy unikatowe (X.GODZINY_PRZYJEC_PK)
24600001. 00000 - "unique constraint (%s.%s) violated"
247*Cause: An UPDATE or INSERT statement attempted to insert a duplicate key.
248 For Trusted Oracle configured in DBMS MAC mode, you may see
249 this message if a duplicate entry exists at a different level.
250*Action: Either remove the unique restriction or do not insert the key.