rendered paste body
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