'I AM CREATING CONSTRAINTS IN A TABLE
CREATE TABLE ACTORS
(
ACTOR_ID NUMBER(10),
STAGE_NAME VARCHAR2(40) NOT NULL,
FIRST_NAME VARCHAR2(25) NOT NULL,
LAST_NAME VARCHAR2(25) NOT NULL,
BIRTH_DATE DATE
);
ALTER TABLE ACTORS
ADD CONSTRAINTS PK_ACTOR_ID PRIMARY KEY(ACTOR_ID);
ALTER TABLE ACTORS
ADD CONSTRAINTS FK_
FOREIGN KEY(STAR_BILLING_ID) REFERENCES STAR_BILLINGS(STAR_BILLING_ID);
CREATE TABLE STAR_BILLINGS
(
ACTOR_ID NUMBER(10) NOT NULL,
TITLE_ID NUMBER(10) NOT NULL,
STAR_BILLING_ID INT GENERATED ALWAYS AS IDENTITY,
COMMENTS VARCHAR2(40)
);
Error:
ORA-00904: "STAR_BILLING_ID": invalid identifier ORA-06512
Sources
This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.
Source: Stack Overflow
| Solution | Source |
|---|
