INSERT INTO TIPO VALUES
(1,'Canoa', 300);


INSERT INTO TIPO VALUES
(2,'Barco', 10000);


INSERT INTO TIPO VALUES
(3,'Navios', 100000);

SELECT *
FROM TIPO;

INSERT INTO EMBARCACAO VALUES
(1, 2, 3, 'Poseidon');


INSERT INTO EMBARCACAO VALUES
(2, 3, 2,'Titanic');


INSERT INTO EMBARCACAO VALUES
(3, 2, 2,'Ana Luzia');

SELECT *
FROM EMBARCACAO;

INSERT INTO PROPRIETARIO VALUES
(1,'Joaquim Manuel', 'fisica', '(12) 3947-0001');


INSERT INTO PROPRIETARIO VALUES
(2,'Jose da Silva', 'fisica', '(12) 3947-0002');


INSERT INTO PROPRIETARIO VALUES
(3,'MADEIRA SA', 'juridica', '(12) 3947-0003');

SELECT *
FROM PROPRIETARIO;


INSERT INTO CARGA VALUES
(1, 1, 1, 300, 60000, 500000);

INSERT INTO CARGA VALUES
(2, 2, 1, 400, 30000, 300000);

INSERT INTO CARGA VALUES
(3, 3, 3, 500, 50000, 400000);

SELECT *
FROM CARGA;


INSERT INTO NATUREZA VALUES
(1, 'baixa', 'baixa', 'media','Madeira');


INSERT INTO NATUREZA VALUES
(2, 'alta', 'alta', 'baixa','Acido Sulfurico');


INSERT INTO NATUREZA VALUES
(3, 'alta', 'alta', 'alta','Petroleo');

SELECT *
FROM NATUREZA;


INSERT INTO TRIPULANTE VALUES
(1,'Ze de Souza', 2, 'capitao', '(12) 3947-0003');


INSERT INTO TRIPULANTE VALUES
(2,'Moacir Matos Junior', 3, 'Marujo', '(12) 3947-0004');


INSERT INTO TRIPULANTE VALUES
(3,'Joao Macedo', 3, 'capitao', '(12) 3947-0005');

SELECT *
FROM TRIPULANTE;


INSERT INTO EMPREGADO VALUES
(1,'Marcos Rosa', 2, 'Janitor', '(12) 3947-0006');


INSERT INTO EMPREGADO VALUES
(2,'Moacir Matos Junior', 3, 'Operador', '(12) 3947-0007');


INSERT INTO EMPREGADO VALUES
(3,'Herbert Fonseca', 3, 'Gerente', '(12) 3947-0008');

SELECT *
FROM EMPREGADO;


INSERT INTO ATRACACAO VALUES
(1,2,1,to_date('2007/05/17:09:00:00AM', 'yyyy/mm/dd:hh:mi:ssam'), to_date('2007/05/17:06:00:00PM', 'yyyy/mm/dd:hh:mi:ssam'));

INSERT INTO ATRACACAO VALUES
(2,2,2,to_date('2007/05/20:08:00:00AM', 'yyyy/mm/dd:hh:mi:ssam'), to_date('2007/05/20:03:00:00PM', 'yyyy/mm/dd:hh:mi:ssam'));

INSERT INTO ATRACACAO VALUES
(3,3,2,to_date('2007/05/19:04:00:00AM', 'yyyy/mm/dd:hh:mi:ssam'), to_date('2007/05/19:07:00:00PM', 'yyyy/mm/dd:hh:mi:ssam'));

INSERT INTO ATRACACAO VALUES
(4,3,1,to_date('2007/05/25:10:00:00AM', 'yyyy/mm/dd:hh:mi:ssam'), to_date('2007/05/25:09:00:00PM', 'yyyy/mm/dd:hh:mi:ssam'));

SELECT *
FROM ATRACACAO;


INSERT INTO MOVIMENTO_CARGA VALUES
(1,1,1,'carga');


INSERT INTO MOVIMENTO_CARGA VALUES
(2,2,1,'descarga');


INSERT INTO MOVIMENTO_CARGA VALUES
(3,3,2,'carga');


INSERT INTO MOVIMENTO_CARGA VALUES
(4,4,2,'descarga');


INSERT INTO MOVIMENTO_CARGA VALUES
(5,3,3,'carga');


INSERT INTO MOVIMENTO_CARGA VALUES
(6,4,3,'descarga');

SELECT *
FROM MOVIMENTO_CARGA;

INSERT INTO EXTREMO_ROTA VALUES
(1,1, 1);

INSERT INTO EXTREMO_ROTA VALUES
(2,1, 2);

INSERT INTO EXTREMO_ROTA VALUES
(3,2, 3);

INSERT INTO EXTREMO_ROTA VALUES
(4,2, 4);

SELECT *
FROM EXTREMO_ROTA;


INSERT INTO ROTA VALUES
(1,'Rota da Madeira - ida', 'alta');

INSERT INTO ROTA VALUES
(2,'Rota da Madeira - volta', 'alta');

INSERT INTO ROTA VALUES
(3,'Rota do Ouro ida', 'media');

SELECT *
FROM ROTA;


INSERT INTO DESCRICAO_ROTA VALUES
(1,1,1);

INSERT INTO DESCRICAO_ROTA VALUES
(2,1,2);

INSERT INTO DESCRICAO_ROTA VALUES
(3,2,1);

INSERT INTO DESCRICAO_ROTA VALUES
(4,2,2);

SELECT *
FROM DESCRICAO_ROTA;


INSERT INTO TRECHO VALUES
(1,58,89,1);

INSERT INTO TRECHO VALUES
(2,36,90,2);

INSERT INTO TRECHO VALUES
(3,50,79,3);

SELECT *
FROM TRECHO;


INSERT INTO RIO VALUES
(1,'Amazonas',2000);


INSERT INTO RIO VALUES
(2,'Solimoes',300);


INSERT INTO RIO VALUES
(3,'Jaima',500);

SELECT *
FROM RIO;


INSERT INTO PORTO VALUES
(1,'Porto de Manaus','Rua Santa Maria, 30',MDSYS.SDO_GEOMETRY(2001,NULL,MDSYS.SDO_POINT_TYPE(-2.0,-10.1,50.0),NULL,NULL));


INSERT INTO PORTO VALUES
(2,'Porto de Japioca','Av JK, 3000',MDSYS.SDO_GEOMETRY(2001,NULL,MDSYS.SDO_POINT_TYPE(-5.0,-30.1,50.0),NULL,NULL));


INSERT INTO PORTO VALUES
(3,'Porto de Baiatuba','Rodovia dos Madeireiros, 200',MDSYS.SDO_GEOMETRY(2001,NULL,MDSYS.SDO_POINT_TYPE(10.0,20.1,50.0),NULL,NULL));

SELECT *
FROM PORTO;