CREATE TABLE StudijniProgram
*
ERROR at line 1:
ORA-00955: name is already used by an existing object
CREATE TABLE Pravidla
*
ERROR at line 1:
ORA-00955: name is already used by an existing object
CREATE TABLE Predmet
*
ERROR at line 1:
ORA-00955: name is already used by an existing object
CREATE TABLE Student
*
ERROR at line 1:
ORA-00955: name is already used by an existing object
CREATE TABLE Ucitel
*
ERROR at line 1:
ORA-00955: name is already used by an existing object
CREATE TABLE studuje
*
ERROR at line 1:
ORA-00955: name is already used by an existing object
CREATE TABLE vyucuje
*
ERROR at line 1:
ORA-00955: name is already used by an existing object
CREATE sequence inc_student
*
ERROR at line 1:
ORA-00955: name is already used by an existing object
CREATE sequence inc_ucitel
*
ERROR at line 1:
ORA-00955: name is already used by an existing object
INSERT INTO StudijniProgram VALUES(1, 'Bakalarsky', 750)
*
ERROR at line 1:
ORA-00001: unique constraint (STUDENT.SYS_C005253) violated
INSERT INTO Pravidla VALUES(1, 1, 15, 70, 180, 210)
*
ERROR at line 1:
ORA-00001: unique constraint (STUDENT.SYS_C005254) violated
INSERT INTO Predmet VALUES(1, 1, 'Zaklady Programovani', 50, to_date('01-01-2010', 'DD-MM-YYYY'), 1,
*
ERROR at line 1:
ORA-00001: unique constraint (STUDENT.SYS_C005258) violated
1 row created.
1 row created.
1 row created.
1 row created.
1 row created.
1 row created.
1 row created.
1 row created.
1 row created.
1 row created.
1 row created.
1 row created.
KOD_PREDMET NAZEV
----------- ------------------------------
1 Zaklady Programovani
KOD_STUDENT JMENO PRIJMENI
----------- ------------------------------ ------------------------------
1 Pavel Zuna
2 Honza Novak
3 Jiri Novotny
4 Jana Halova
41 Pavel Zuna
42 Honza Novak
43 Jiri Novotny
44 Jana Halova
8 rows selected.
KOD_UCITEL JMENO PRIJMENI
---------- ------------------------------ ------------------------------
1 Bohuslav Stefan
2 Karel Branka
1 Bohuslav Stefan
2 Karel Branka
SEMESTR AVG(STUDENT.KREDITY)
--------- --------------------
1 34
SELECT P.kod_predmet, P.nazev, SUM(V.*) FROM Predmet P, vyucuje V WHERE P.kod_predmet = V.kod_predme
*
ERROR at line 1:
ORA-01747: invalid user.table.column, table.column, or column specification
KOD_UCITEL JMENO PRIJMENI
---------- ------------------------------ ------------------------------
1 Bohuslav Stefan
2 Karel Branka
KOD_UCITEL JMENO PRIJMENI
---------- ------------------------------ ------------------------------
1 Bohuslav Stefan
2 Karel Branka
41 Bohuslav Stefan
42 Karel Branka