Problem quoting table names
603410Dec 7 2007 — edited Dec 7 2007Hi,
I want to use my tables capitalized, but something is not working right. I am using Oracle Database Express Edition 2.1.0.00.39.
Creating and altering a table as follows works:
"CREATE TABLE Mitarbeiter (
MA_ID number NOT NULL,
ORG_ID number NOT NULL,
Nachname char(128) NOT NULL,
Vorname char(128) NOT NULL,
Geburtsdatum date NOT NULL,
Kommentar varchar2(100),
Rang char(3) DEFAULT 'MA' NOT NULL,
PRIMARY KEY ( MA_ID )
);
ALTER TABLE Mitarbeiter ADD CONSTRAINT OrgEinheit FOREIGN KEY ( ORG_ID ) REFERENCES OrgEinheit ( ORG_ID );
"
If I quote the table name like
"CREATE TABLE "Mitarbeiter" (
MA_ID number NOT NULL,
ORG_ID number NOT NULL,
Nachname char(128) NOT NULL,
Vorname char(128) NOT NULL,
Geburtsdatum date NOT NULL,
Kommentar varchar2(100),
Rang char(3) DEFAULT 'MA' NOT NULL,
PRIMARY KEY ( MA_ID )
);
ALTER TABLE "Mitarbeiter" ADD CONSTRAINT OrgEinheit FOREIGN KEY ( ORG_ID ) REFERENCES OrgEinheit ( ORG_ID );
"
the alter statement is not executed successfully. I get the error message "ORA-00942 table or view does not exist".
Who can help?
Udo