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