Hallo Leute,
ich versuche schon seit stunden fehler zu finden, aber komme ich nicht weiter. kann vieleicht jemand mein code anschauen?
SQL> @kino
SP2-0042: unknown command ")" - rest of line ignored.
SP2-0042: unknown command ")" - rest of line ignored.
SP2-0042: unknown command ")" - rest of line ignored.
SP2-0042: unknown command ")" - rest of line ignored.
SP2-0042: unknown command ")" - rest of line ignored.
SP2-0042: unknown command ")" - rest of line ignored.
SP2-0042: unknown command ")" - rest of line ignored.
SP2-0042: unknown command ")" - rest of line ignored.
SP2-0734: unknown command beginning "kId VARCH..." - rest of line ignored.
SP2-0734: unknown command beginning "szvNr NU..." - rest of line ignored.
SP2-0734: unknown command beginning "geschlecht..." - rest of line ignored.
SP2-0734: unknown command beginning "CONSTRAINT..." - rest of line ignored.
SP2-0044: For a list of known commands enter HELP
and to leave enter EXIT.
SP2-0734: unknown command beginning "CONSTRAINT..." - rest of line ignored.
SP2-0734: unknown command beginning "CONSTRAINT..." - rest of line ignored.
SP2-0042: unknown command ")" - rest of line ignored.
CREATE TABLE mitarbeiter (
*
ERROR at line 1:
ORA-00955: name is already used by an existing object
SP2-0734: unknown command beginning "CONSTRAINT..." - rest of line ignored.
SP2-0734: unknown command beginning "CONSTRAINT..." - rest of line ignored.
SP2-0734: unknown command beginning "CONSTRAINT..." - rest of line ignored.
SP2-0042: unknown command ")" - rest of line ignored.
SP2-0044: For a list of known commands enter HELP
and to leave enter EXIT.
SQL>
ich wäre euch sehr dankbar
sahra
ich versuche schon seit stunden fehler zu finden, aber komme ich nicht weiter. kann vieleicht jemand mein code anschauen?
SQL:
CREATE TABLE sall(
name VARCHAR2(5) NOT NULL,
leinwandgoesse NUMBER(2),
CONSTRAINT sall_pk PRIMARY KEY(name)
);
CREATE TABLE platz(
reihe NUMBER(2),
platz NUMBER(2),
name_kino VARCHAR2(5) NOT NULL,
CONSTRAINT platz_pk PRIMARY KEY(name,reihe,platz),
CONSTRAINT platz_fk_name FOREIGN KEY(name_kino) REFERENCES sall ON DELETE CASCADE
);
CREATE TABLE film(
titel VARCHAR2(30) NOT NULL,
zulassungsalter NUMBER(2),
erscheinungsjahr DATE,
name_sall VARCHAR2(5) NOT NULL,
CONSTRAINT film_pk_titel PRIMARY KEY(titel),
CONSTRAINT film_fk_name FOREIGN KEY(name_sall) REFERENCES sall ON DELETE CASCADE
);
CREATE TABLE ticket(
ticketId VARCHAR2(3) NOT NULL,
datum DATE,
titel_film VARCHAR2(30) NOT NULL,
preis NUMBER(2),
CONSTRAINT ticket_pk_ticketId PRIMARY KEY(ticketId),
CONSTRAINT ticket_fk_titel FOREIGN KEY(titel_film) REFERENCES film ON DELETE CASCADE
);
CREATE TABLE kauft(
ticketId VARCHAR2(3) NOT NULL,
kId VARCHAR2(4) NOT NULL,
titel VARCHAR2(30)NOT NULL,
CONSTRAINT kauft PRIMARY KEY(ticketId,kId,titel),
CONSTRAINT kauft_fk_ticketId FOREIGN KEY(ticketId) REFERENCES ticket ON DELETE CASCADE,
CONSTRAINT kauft_fk_kId FOREIGN KEY(kId) REFERENCES kunde ON DELETE CASCADE,
CONSTRAINT kauft_fk_titel FOREIGN KEY(titel) REFERENCES film ON DELETE CASCADE
)
CREATE TABLE kassa(
nummer VARCHAR2(2),
CONSTRAINT kassa_pk PRIMARY KEY (nummer)
);
CREATE TABLE buchung(
kId VARCHAR2(4),
ticketId VARCHAR2(3) NOT NULL,
datum DATE,
CONSTRAINT buchung_pk PRIMARY KEY(kId,ticketId),
CONSTRAINT buchung_fk FOREIGN KEY(kId) REFERENCES person ON DELETE CASCADE,
CONSTRAINT buchung_fk FOREIGN KEY(ticketId) REFERENCES ticket ON DELETE CASCADE
);
CREATE TABLE person(
szvNr NUMBER(4),
vorname VARCHAR2(10) NOT NULL,
nachname VARCHAR2(20)NOT NULL,
CONSTRAINT person_pk PRIMARY KEY(szvNr)
);
CREATE TABLE kunde(
kId VARCHAR2(4),
szvNr NUMBER(4),
geschlecht CHAR(1),
CONSTRAINT kunde_pk PRIMARY KEY(kId),
CONSTRAINT kunde_fk_person FOREIGN KEY (szvNr) REFERENCES person ON DELETE CASCADE,
CONSTRAINT kunde_geschlecht CHECK(geschlecht in('m','w'))
);
CREATE TABLE mitarbeiter (
persNr NUMBER(3),
chef INTEGER,
szvnr NUMBER(4),
CONSTRAINT ma_pk PRIMARY KEY(persNr),
CONSTRAINT ma_fk_person FOREIGN KEY (szvNr) REFERENCES person ON DELETE CASCADE,
CONSTRAINT ma_fk_chef FOREIGN KEY (chef) REFERENCES mitarbeiter(persNr)
);
CREATE TABLE arbeitet(
nummer VARCHAR2(2) NOT NULL,
persNr NUMBER(3),
CONSTRAINT arbeitet_pk PRIMARY KEY(nummer, persNr),
CONSTRAINT arbeitet_fk_nummer FOREIGN KEY(nummer) REFERENCES kassa ON DELETE CASCADE,
CONSTRAINT arbeitet_fk_persNr FOREIGN KEY(persNr) REFERENCES mitarbeiter ON DELETE CASCADE
);
SQL> @kino
SP2-0042: unknown command ")" - rest of line ignored.
SP2-0042: unknown command ")" - rest of line ignored.
SP2-0042: unknown command ")" - rest of line ignored.
SP2-0042: unknown command ")" - rest of line ignored.
SP2-0042: unknown command ")" - rest of line ignored.
SP2-0042: unknown command ")" - rest of line ignored.
SP2-0042: unknown command ")" - rest of line ignored.
SP2-0042: unknown command ")" - rest of line ignored.
SP2-0734: unknown command beginning "kId VARCH..." - rest of line ignored.
SP2-0734: unknown command beginning "szvNr NU..." - rest of line ignored.
SP2-0734: unknown command beginning "geschlecht..." - rest of line ignored.
SP2-0734: unknown command beginning "CONSTRAINT..." - rest of line ignored.
SP2-0044: For a list of known commands enter HELP
and to leave enter EXIT.
SP2-0734: unknown command beginning "CONSTRAINT..." - rest of line ignored.
SP2-0734: unknown command beginning "CONSTRAINT..." - rest of line ignored.
SP2-0042: unknown command ")" - rest of line ignored.
CREATE TABLE mitarbeiter (
*
ERROR at line 1:
ORA-00955: name is already used by an existing object
SP2-0734: unknown command beginning "CONSTRAINT..." - rest of line ignored.
SP2-0734: unknown command beginning "CONSTRAINT..." - rest of line ignored.
SP2-0734: unknown command beginning "CONSTRAINT..." - rest of line ignored.
SP2-0042: unknown command ")" - rest of line ignored.
SP2-0044: For a list of known commands enter HELP
and to leave enter EXIT.
SQL>
ich wäre euch sehr dankbar
sahra