prompt PL/SQL Developer import file
prompt Created on domingo, 14 de dezembro de 2014 by Administrador
set feedback off
set define off
prompt Creating CADASTRO...
create table CADASTRO
(
  id         NUMBER not null,
  first_name VARCHAR2(20),
  last_name  VARCHAR2(25)
)
tablespace SYSTEM
  pctfree 10
  pctused 40
  initrans 1
  maxtrans 255
  storage
  (
    initial 64K
    minextents 1
    maxextents unlimited
  );

prompt Creating PRO_PAIS...
create table PRO_PAIS
(
  cdpais NUMBER not null,
  nmpais VARCHAR2(40) not null
)
tablespace SYSTEM
  pctfree 10
  pctused 40
  initrans 1
  maxtrans 255
  storage
  (
    initial 64K
    minextents 1
    maxextents unlimited
  );
alter table PRO_PAIS
  add constraint PRO_PAIS_PK primary key (CDPAIS)
  using index 
  tablespace SYSTEM
  pctfree 10
  initrans 2
  maxtrans 255
  storage
  (
    initial 64K
    minextents 1
    maxextents unlimited
  );
alter table PRO_PAIS
  add constraint NM_PAIS_UK unique (NMPAIS)
  using index 
  tablespace SYSTEM
  pctfree 10
  initrans 2
  maxtrans 255
  storage
  (
    initial 64K
    minextents 1
    maxextents unlimited
  );

prompt Creating FABRICA...
create table FABRICA
(
  cd_fab NUMBER not null,
  nm_fab VARCHAR2(40),
  cdpais NUMBER not null
)
tablespace SYSTEM
  pctfree 10
  pctused 40
  initrans 1
  maxtrans 255
  storage
  (
    initial 64K
    minextents 1
    maxextents unlimited
  );
alter table FABRICA
  add constraint FABRICA_PK primary key (CD_FAB)
  using index 
  tablespace SYSTEM
  pctfree 10
  initrans 2
  maxtrans 255
  storage
  (
    initial 64K
    minextents 1
    maxextents unlimited
  );
alter table FABRICA
  add constraint FABRICA_PRO_PAIS_FK foreign key (CDPAIS)
  references PRO_PAIS (CDPAIS);

prompt Creating CONCES...
create table CONCES
(
  cd_con    NUMBER not null,
  nm_conces VARCHAR2(40),
  cd_fab    NUMBER not null
)
tablespace SYSTEM
  pctfree 10
  pctused 40
  initrans 1
  maxtrans 255
  storage
  (
    initial 64K
    minextents 1
    maxextents unlimited
  );
alter table CONCES
  add constraint CONCES_PK primary key (CD_CON)
  using index 
  tablespace SYSTEM
  pctfree 10
  initrans 2
  maxtrans 255
  storage
  (
    initial 64K
    minextents 1
    maxextents unlimited
  );
alter table CONCES
  add constraint CONCES_FABRICA_FK foreign key (CD_FAB)
  references FABRICA (CD_FAB);

prompt Creating EMPRESA_TESTE...
create table EMPRESA_TESTE
(
  codigo        NUMBER(20) not null,
  nome          VARCHAR2(2000),
  nome_fantasia VARCHAR2(2000),
  cnpj          VARCHAR2(100)
)
tablespace SYSTEM
  pctfree 10
  pctused 40
  initrans 1
  maxtrans 255
  storage
  (
    initial 64K
    minextents 1
    maxextents unlimited
  );

prompt Creating MOTOR...
create table MOTOR
(
  cd_motor      NUMBER not null,
  tipo_motor    NUMBER(10,2),
  veloc_inicial NUMBER,
  veloc_final   NUMBER
)
tablespace SYSTEM
  pctfree 10
  pctused 40
  initrans 1
  maxtrans 255
  storage
  (
    initial 64K
    minextents 1
    maxextents unlimited
  );
alter table MOTOR
  add constraint MOTOR_PK primary key (CD_MOTOR)
  using index 
  tablespace SYSTEM
  pctfree 10
  initrans 2
  maxtrans 255
  storage
  (
    initial 64K
    minextents 1
    maxextents unlimited
  );

prompt Creating TIPO_COMB...
create table TIPO_COMB
(
  cd_comb NUMBER not null,
  nm_comb VARCHAR2(40) not null
)
tablespace SYSTEM
  pctfree 10
  pctused 40
  initrans 1
  maxtrans 255
  storage
  (
    initial 64K
    minextents 1
    maxextents unlimited
  );
alter table TIPO_COMB
  add constraint TIPO_COMB_PK primary key (CD_COMB)
  using index 
  tablespace SYSTEM
  pctfree 10
  initrans 2
  maxtrans 255
  storage
  (
    initial 64K
    minextents 1
    maxextents unlimited
  );

prompt Creating VEICULO...
create table VEICULO
(
  cd_veic  NUMBER not null,
  nm_veic  VARCHAR2(40) not null,
  dat_fab  DATE,
  dat_mod  DATE,
  cd_motor NUMBER not null,
  cd_fab   NUMBER not null,
  cd_comb  NUMBER not null
)
tablespace SYSTEM
  pctfree 10
  pctused 40
  initrans 1
  maxtrans 255
  storage
  (
    initial 64K
    minextents 1
    maxextents unlimited
  );
alter table VEICULO
  add constraint VEICULO_PK primary key (CD_VEIC)
  using index 
  tablespace SYSTEM
  pctfree 10
  initrans 2
  maxtrans 255
  storage
  (
    initial 64K
    minextents 1
    maxextents unlimited
  );
alter table VEICULO
  add constraint VEICULO_UN unique (CD_FAB, NM_VEIC, CD_MOTOR, CD_COMB)
  using index 
  tablespace SYSTEM
  pctfree 10
  initrans 2
  maxtrans 255
  storage
  (
    initial 64K
    minextents 1
    maxextents unlimited
  );
alter table VEICULO
  add constraint VEICULO_FABRICA foreign key (CD_FAB)
  references FABRICA (CD_FAB);
alter table VEICULO
  add constraint VEICULO_MOTOR_FK foreign key (CD_MOTOR)
  references MOTOR (CD_MOTOR);
alter table VEICULO
  add constraint VEICULO_TIPO_COMB_FK foreign key (CD_COMB)
  references TIPO_COMB (CD_COMB);

prompt Creating ESTOQ...
create table ESTOQ
(
  cd_est   NUMBER not null,
  qt_veic  NUMBER,
  val_veic NUMBER(10,2),
  cd_con   NUMBER not null,
  cd_veic  NUMBER not null
)
tablespace SYSTEM
  pctfree 10
  pctused 40
  initrans 1
  maxtrans 255
  storage
  (
    initial 64K
    minextents 1
    maxextents unlimited
  );
alter table ESTOQ
  add constraint ESTOQ_PK primary key (CD_EST)
  using index 
  tablespace SYSTEM
  pctfree 10
  initrans 2
  maxtrans 255
  storage
  (
    initial 64K
    minextents 1
    maxextents unlimited
  );
alter table ESTOQ
  add constraint ESTOQ_CONCES_FK foreign key (CD_CON)
  references CONCES (CD_CON);
alter table ESTOQ
  add constraint ESTOQ_VEICULO_FK foreign key (CD_VEIC)
  references VEICULO (CD_VEIC);

prompt Disabling triggers for CADASTRO...
alter table CADASTRO disable all triggers;
prompt Disabling triggers for PRO_PAIS...
alter table PRO_PAIS disable all triggers;
prompt Disabling triggers for FABRICA...
alter table FABRICA disable all triggers;
prompt Disabling triggers for CONCES...
alter table CONCES disable all triggers;
prompt Disabling triggers for EMPRESA_TESTE...
alter table EMPRESA_TESTE disable all triggers;
prompt Disabling triggers for MOTOR...
alter table MOTOR disable all triggers;
prompt Disabling triggers for TIPO_COMB...
alter table TIPO_COMB disable all triggers;
prompt Disabling triggers for VEICULO...
alter table VEICULO disable all triggers;
prompt Disabling triggers for ESTOQ...
alter table ESTOQ disable all triggers;
prompt Disabling foreign key constraints for FABRICA...
alter table FABRICA disable constraint FABRICA_PRO_PAIS_FK;
prompt Disabling foreign key constraints for CONCES...
alter table CONCES disable constraint CONCES_FABRICA_FK;
prompt Disabling foreign key constraints for VEICULO...
alter table VEICULO disable constraint VEICULO_FABRICA;
alter table VEICULO disable constraint VEICULO_MOTOR_FK;
alter table VEICULO disable constraint VEICULO_TIPO_COMB_FK;
prompt Disabling foreign key constraints for ESTOQ...
alter table ESTOQ disable constraint ESTOQ_CONCES_FK;
alter table ESTOQ disable constraint ESTOQ_VEICULO_FK;
prompt Loading CADASTRO...
insert into CADASTRO (id, first_name, last_name)
values (1, 'Aluno1', 'Proway1');
insert into CADASTRO (id, first_name, last_name)
values (2, 'Aluno2', 'Proway2');
insert into CADASTRO (id, first_name, last_name)
values (3, 'Aluno3', 'Proway3');
insert into CADASTRO (id, first_name, last_name)
values (4, 'Aluno4', 'Proway4');
insert into CADASTRO (id, first_name, last_name)
values (5, 'Aluno5', 'Proway5');
commit;
prompt 5 records loaded
prompt Loading PRO_PAIS...
insert into PRO_PAIS (cdpais, nmpais)
values (13, 'ARGENTINA');
insert into PRO_PAIS (cdpais, nmpais)
values (14, 'MÉXICO');
insert into PRO_PAIS (cdpais, nmpais)
values (15, 'ALEMANHA');
insert into PRO_PAIS (cdpais, nmpais)
values (16, 'CHINA');
insert into PRO_PAIS (cdpais, nmpais)
values (17, 'BRASIL');
insert into PRO_PAIS (cdpais, nmpais)
values (19, 'USA');
commit;
prompt 6 records loaded
prompt Loading FABRICA...
insert into FABRICA (cd_fab, nm_fab, cdpais)
values (2, 'FIAT', 13);
insert into FABRICA (cd_fab, nm_fab, cdpais)
values (3, 'FORD', 19);
insert into FABRICA (cd_fab, nm_fab, cdpais)
values (4, 'AUDI', 15);
insert into FABRICA (cd_fab, nm_fab, cdpais)
values (5, 'GM', 19);
insert into FABRICA (cd_fab, nm_fab, cdpais)
values (1, 'VW', 17);
insert into FABRICA (cd_fab, nm_fab, cdpais)
values (6, 'CHERY', 16);
commit;
prompt 6 records loaded
prompt Loading CONCES...
insert into CONCES (cd_con, nm_conces, cd_fab)
values (3, 'CENTER', 3);
insert into CONCES (cd_con, nm_conces, cd_fab)
values (1, 'BLUSA', 1);
insert into CONCES (cd_con, nm_conces, cd_fab)
values (2, 'BARIGUI', 2);
insert into CONCES (cd_con, nm_conces, cd_fab)
values (4, 'BREITKOPF', 4);
insert into CONCES (cd_con, nm_conces, cd_fab)
values (5, 'AUTO SHOW', 5);
commit;
prompt 5 records loaded
prompt Loading EMPRESA_TESTE...
prompt Table is empty
prompt Loading MOTOR...
insert into MOTOR (cd_motor, tipo_motor, veloc_inicial, veloc_final)
values (1, 1, 0, 120);
insert into MOTOR (cd_motor, tipo_motor, veloc_inicial, veloc_final)
values (2, 1.4, 0, 160);
insert into MOTOR (cd_motor, tipo_motor, veloc_inicial, veloc_final)
values (3, 1.6, 0, 180);
insert into MOTOR (cd_motor, tipo_motor, veloc_inicial, veloc_final)
values (4, 1.8, 0, 220);
insert into MOTOR (cd_motor, tipo_motor, veloc_inicial, veloc_final)
values (5, 2, 0, 260);
commit;
prompt 5 records loaded
prompt Loading TIPO_COMB...
insert into TIPO_COMB (cd_comb, nm_comb)
values (1, 'ÁLCOOL');
insert into TIPO_COMB (cd_comb, nm_comb)
values (2, 'GASOLINA');
insert into TIPO_COMB (cd_comb, nm_comb)
values (3, 'ÁLCOOL_GASOLINA');
insert into TIPO_COMB (cd_comb, nm_comb)
values (4, 'GÁS NATURAL');
commit;
prompt 4 records loaded
prompt Loading VEICULO...
insert into VEICULO (cd_veic, nm_veic, dat_fab, dat_mod, cd_motor, cd_fab, cd_comb)
values (1, 'GOL', to_date('01-03-2014', 'dd-mm-yyyy'), to_date('01-02-2014', 'dd-mm-yyyy'), 1, 1, 1);
insert into VEICULO (cd_veic, nm_veic, dat_fab, dat_mod, cd_motor, cd_fab, cd_comb)
values (2, 'UNO', to_date('01-04-2014', 'dd-mm-yyyy'), to_date('01-02-2015', 'dd-mm-yyyy'), 3, 2, 2);
insert into VEICULO (cd_veic, nm_veic, dat_fab, dat_mod, cd_motor, cd_fab, cd_comb)
values (3, 'FIESTA', to_date('10-01-2014', 'dd-mm-yyyy'), to_date('01-02-2014', 'dd-mm-yyyy'), 1, 3, 1);
insert into VEICULO (cd_veic, nm_veic, dat_fab, dat_mod, cd_motor, cd_fab, cd_comb)
values (4, 'A3', to_date('15-02-2014', 'dd-mm-yyyy'), to_date('01-02-2014', 'dd-mm-yyyy'), 4, 4, 2);
insert into VEICULO (cd_veic, nm_veic, dat_fab, dat_mod, cd_motor, cd_fab, cd_comb)
values (5, 'CRUZE', to_date('28-12-2013', 'dd-mm-yyyy'), to_date('01-02-2014', 'dd-mm-yyyy'), 4, 5, 2);
insert into VEICULO (cd_veic, nm_veic, dat_fab, dat_mod, cd_motor, cd_fab, cd_comb)
values (6, 'CELER', to_date('23-03-2014', 'dd-mm-yyyy'), to_date('01-01-2015', 'dd-mm-yyyy'), 3, 6, 1);
insert into VEICULO (cd_veic, nm_veic, dat_fab, dat_mod, cd_motor, cd_fab, cd_comb)
values (7, 'UP', to_date('20-02-2014', 'dd-mm-yyyy'), to_date('01-01-2015', 'dd-mm-yyyy'), 2, 1, 2);
insert into VEICULO (cd_veic, nm_veic, dat_fab, dat_mod, cd_motor, cd_fab, cd_comb)
values (8, 'PRISMA', to_date('23-03-2014', 'dd-mm-yyyy'), to_date('01-01-2015', 'dd-mm-yyyy'), 1, 5, 2);
insert into VEICULO (cd_veic, nm_veic, dat_fab, dat_mod, cd_motor, cd_fab, cd_comb)
values (9, 'ONIX', to_date('10-01-2014', 'dd-mm-yyyy'), to_date('01-01-2015', 'dd-mm-yyyy'), 2, 5, 2);
commit;
prompt 9 records loaded
prompt Loading ESTOQ...
insert into ESTOQ (cd_est, qt_veic, val_veic, cd_con, cd_veic)
values (1, 100, 29900, 1, 1);
insert into ESTOQ (cd_est, qt_veic, val_veic, cd_con, cd_veic)
values (2, 200, 25300, 2, 2);
insert into ESTOQ (cd_est, qt_veic, val_veic, cd_con, cd_veic)
values (3, 95, 35400, 3, 3);
insert into ESTOQ (cd_est, qt_veic, val_veic, cd_con, cd_veic)
values (4, 20, 85500, 4, 4);
insert into ESTOQ (cd_est, qt_veic, val_veic, cd_con, cd_veic)
values (5, 40, 69000, 5, 5);
insert into ESTOQ (cd_est, qt_veic, val_veic, cd_con, cd_veic)
values (6, 200, 23990.99, 5, 8);
insert into ESTOQ (cd_est, qt_veic, val_veic, cd_con, cd_veic)
values (7, 50, 28890, 1, 7);
commit;
prompt 7 records loaded
prompt Enabling foreign key constraints for FABRICA...
alter table FABRICA enable constraint FABRICA_PRO_PAIS_FK;
prompt Enabling foreign key constraints for CONCES...
alter table CONCES enable constraint CONCES_FABRICA_FK;
prompt Enabling foreign key constraints for VEICULO...
alter table VEICULO enable constraint VEICULO_FABRICA;
alter table VEICULO enable constraint VEICULO_MOTOR_FK;
alter table VEICULO enable constraint VEICULO_TIPO_COMB_FK;
prompt Enabling foreign key constraints for ESTOQ...
alter table ESTOQ enable constraint ESTOQ_CONCES_FK;
alter table ESTOQ enable constraint ESTOQ_VEICULO_FK;
prompt Enabling triggers for CADASTRO...
alter table CADASTRO enable all triggers;
prompt Enabling triggers for PRO_PAIS...
alter table PRO_PAIS enable all triggers;
prompt Enabling triggers for FABRICA...
alter table FABRICA enable all triggers;
prompt Enabling triggers for CONCES...
alter table CONCES enable all triggers;
prompt Enabling triggers for EMPRESA_TESTE...
alter table EMPRESA_TESTE enable all triggers;
prompt Enabling triggers for MOTOR...
alter table MOTOR enable all triggers;
prompt Enabling triggers for TIPO_COMB...
alter table TIPO_COMB enable all triggers;
prompt Enabling triggers for VEICULO...
alter table VEICULO enable all triggers;
prompt Enabling triggers for ESTOQ...
alter table ESTOQ enable all triggers;
set feedback on
set define on
prompt Done.