SQL error: ORA-00904: invalid identifier

Question

SQL error: ORA-00904: invalid identifier

Navigation

#1 by (2 votes)

0

I'm starting with SQL and it gives me an error

SQL: ORA-00904: invalid identifier

When creating a table with a foreign key that is correctly written. I leave the code in case I have implemented something wrong. Thank you. The error is in FK of TRABAJADORES .

DROP TABLE CLINICAS;

DROP TABLE RECEPCIONISTAS;

--CREACIÓN DE TABLAS

CREATE TABLE CLINICAS

  (OID_CLINICA NUMBER NOT NULL,
  NOMBRE VARCHAR2(20)NOT NULL,
  DIRECCIÓN VARCHAR2(20) NOT NULL UNIQUE,
  PRIMARY KEY (OID_CLINICA));

CREATE TABLE RECEPCIONISTAS

  (USUARIO VARCHAR2(75) NOT NULL UNIQUE,
  CONTRASEÑA VARCHAR2(75) NOT NULL,
  NOMBRE VARCHAR2(40) NOT NULL,
  APELLIDOS VARCHAR2(40) NOT NULL,
  DNI CHAR(9) NOT NULL UNIQUE,
  EMAIL VARCHAR2(40) NOT NULL UNIQUE,
  TELEFONO VARCHAR2(15) NOT NULL);

CREATE TABLE TRABAJADORES

  (DNI CHAR(9) NOT NULL UNIQUE,
  NOMBRE VARCHAR2(30) NOT NULL,
  APELLIDOS VARCHAR2(40) NOT NULL,
  EMAIL VARCHAR2(40) NOT NULL UNIQUE,
  PRIMARY KEY(DNI),
  FOREIGN KEY(OID_CLINICA) REFERENCES CLINICAS(OID_CLINICA));

sql

asked by Ray 28.07.2017 в 23:09

source

1 answer

Search between dates JDateChoser java mysql how to ask or check if a query brings a specific data

score 2 · Accepted Answer

You still need to add the column OID_CLINICA in the WORKERS table

CREATE TABLE TRABAJADORES

  (DNI CHAR(9) NOT NULL UNIQUE,
  NOMBRE VARCHAR2(30) NOT NULL,
  APELLIDOS VARCHAR2(40) NOT NULL,
  EMAIL VARCHAR2(40) NOT NULL UNIQUE,
  OID_CLINICA NUMBER NOT NULL
  PRIMARY KEY(DNI),
  FOREIGN KEY(OID_CLINICA) REFERENCES CLINICAS(OID_CLINICA));