Table created.


Table created.


Table created.


Table created.


Table created.


Table created.


Table created.


Sequence created.


Sequence 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.


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


KOD_UCITEL JMENO                          PRIJMENI
---------- ------------------------------ ------------------------------
         1 Bohuslav                       Stefan
         2 Karel                          Branka


  SEMESTR AVG(STUDENT.KREDITY)
--------- --------------------
        1                   34

SELECT P.kod_predmet, P.nazev, COUNT(V.*) FROM Predmet P, vyucuje V WHERE P.kod_predmet = V.kod_pred
                                       *
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