Oracle SQL Developer Table Creation

Question

create table socio
(
    id_socio integer Not NULL,
    nome varchar(256)  not NULL,
    cpf  varchar(11) not NULL,
    email varchar(256),
    id_situacao integer,
    constraint socio_id_socio_PK primary key(id_socio),
    constraint socio_id_situacao_FK foreign key(id_situacao) references situacao(id_situacao)
);

CREATE TABLE "SITUACAO" (
    Id_Situacao INTEGER NOT NULL,
    Situacao VARCHAR(10) NOT NULL,
    CONSTRAINT SITUACAO_ID_SITUACAO_PK PRIMARY KEY(Id_Situacao)
);

CREATE TABLE MARCA (
    Id_marca INTEGER not NULL,
    Marca VARCHAR(128) not NULL,
    CONSTRAINT MARCA_ID_MARCA_PK PRIMARY KEY(Id_marca)
);

create table CARRO -- Aqui é a  linha 24
(
    id_CARRO integer Not NULL,
    Modelo VARCHAR(128) not NULL,
    Cor VARCHAR(64) not NULL,
    placa VARCHAR(10) not NULL,
    constraint socio_id_socio_PK primary key(id_CARRO),
    constraint marca_id_marca_FK foreign key(Id_marca) references MARCA(Id_marca),
    constraint socio_id_socio_FK foreign key(id_socio) references socio(id_socio)
);

Answer 1

You should create tables that are used as references in foreign keys first. I suggest the following order:

CREATE TABLE situacao (
  Id_Situacao INTEGER NOT NULL,
  Situacao VARCHAR(10) NOT NULL,
  CONSTRAINT SITUACAO_ID_SITUACAO_PK PRIMARY KEY(Id_Situacao)
);

CREATE TABLE MARCA (
  Id_marca INTEGER not NULL,
  Marca VARCHAR(128) not NULL,
  CONSTRAINT MARCA_ID_MARCA_PK PRIMARY KEY(Id_marca)
);

create table socio (
  id_socio integer Not NULL,
  nome varchar(256) not NULL,
  cpf varchar(11) not NULL,
  email varchar(256),
  id_situacao integer,
  constraint socio_id_socio_PK primary key(id_socio),
  constraint socio_id_situacao_FK foreign key(id_situacao) references situacao(id_situacao)
);

create table CARRO (
  id_CARRO integer Not NULL,
  id_marca integer NOT NULL,
  id_socio integer NOT NULL,
  Modelo VARCHAR(128) not NULL,
  Cor VARCHAR(64) not NULL,
  placa VARCHAR(10) not NULL,
  constraint socio_id_socio_PK primary key(id_CARRO),
  constraint socio_id_situacao_FK foreign key(id_marca) references situacao(id_marca),
  constraint socio_id_situacao_FK foreign key(id_socio) references situacao(id_socio)
);

On the table carro you also have not created the columns that reference the other tables.