Banco de Dados Oracle

...

’F’ , ’(35)-3551-5001’, ’17/10/1980’,0.00);

Insert into CORRENTISTAS values (12,’Liliane Oliveira do Nascimento’, ’F’ , ’(35)-3551-5001’,’01/12/1976’, 0.00);

Insert into CORRENTISTAS values (13,’Maria Luiza Lino’, ’F’ , ’(35)-3551-5001’, ’10/07/1981’, 0.00);

Insert into CORRENTISTAS values (14,’Ronaldo Garcia dos Anjos’, ’M’ , ’(35)-3551-5001’, ’01/12/1976’,0.00);

Insert into CORRENTISTAS values (15,’Samuel Augusto da Silva’, ’M’ , ’(35)-3551-5001’, ’13/12/1976’, 0.00);

/*******************************************************************

* B) Carga da tabela de Movimentos *

********************************************************************/

Insert into MOVIMENTOS values (1,1, 125.50,’C’);

Insert into MOVIMENTOS values (1,2, 10.35,’D’);

Insert into MOVIMENTOS values (2,1, 190.10,’C’);

Insert into MOVIMENTOS values (2,2, 254.50,’D’);

Insert into MOVIMENTOS values (2,3, 671.50,’C’);

Insert into MOVIMENTOS values (3,1, 254.50,’D’);

Insert into MOVIMENTOS values (3,2, 254.50,’D’);

Insert into MOVIMENTOS values (4,1, 671.50,’C’) ;

Insert into MOVIMENTOS values (5,1, 671.50,’C’);

Insert into MOVIMENTOS values (6,1, 254.50,’D’);

Insert into MOVIMENTOS values (6,2, 671.50,’C’);

Insert into MOVIMENTOS values (6,3, 254.50,’D’);

Insert into MOVIMENTOS values (7,1, 671.50,’C’ );

Insert into MOVIMENTOS values (8,1, 254.50,’D’);

Insert into MOVIMENTOS values (9,1, 671.50,’C’);

Insert into MOVIMENTOS values (10,1, 101.10,’C’);

Insert into MOVIMENTOS values (11,1, 71.50,’C’);

Insert into MOVIMENTOS values (12,1, 101.10,’C’);

Insert into MOVIMENTOS values (12,2, 71.50,’C’);

Insert into MOVIMENTOS values (12,3, 71.50,’C’);

Insert into MOVIMENTOS values (13,1, 101.10,’C’);

Insert into MOVIMENTOS values (14,1, 71.50,’C’);

Insert into MOVIMENTOS values (15,1, 71.50,’C’);

Insert into MOVIMENTOS values (15,2, 101.10,’C’);

Insert into MOVIMENTOS values (15,3, 71.50,’C’);

/*******************************************************************

* 03) Update na tabela CORRENTISTAS *

********************************************************************/

/* 03) Fazer um update na tabela CORRENTISTAS para atualizar o campo SALDO

com o VALOR DO MOVIMENTO da tabela movimentos.

*/

SELECT * FROM MOVIMENTOS

SELECT * FROM CORRENTISTAS

Update correntistas A set A.SALDO = (select sum(case B.MOVI when ’D’ then -VALOR else +VALOR end)

from MOVIMENTOS B

WHERE A.CODIGOC = B.CODIGOC

GROUP BY B.CODIGOC);

/*******************************************************************

* F I M - F I M *

********************************************************************/