/* @ej2_Banco */

/****************************************************************/
/*   Eliminar los cambios introducidos por ej1    */
/****************************************************************/

DELETE FROM cliente WHERE dni=179;

DELETE FROM cliente WHERE dni=17171718;

UPDATE prestamo
SET    importe=200000
WHERE  numprestamo=17;

CREATE TABLE prestFormalizado (numero, numprestamo)
AS (SELECT numCuenta,numprestamo
    FROM prestamo);

/* eliminar la columna añadida a prestamo (nueva tabla) */
RENAME prestamo TO oldPrestamo;

CREATE TABLE prestamo (numprestamo,importe,interes)
AS (SELECT numprestamo,importe,interes
    FROM oldPrestamo);

DROP TABLE oldPrestamo;

CREATE TABLE invFormalizada (numero, numInversion)
AS (SELECT numCuenta,numInversion
    FROM inversion);

/* eliminar la columna añadida a inversión (nueva tabla) */
RENAME inversion TO oldInversion;

CREATE TABLE inversion (numInversion,importe,interes)
    AS (SELECT numinversion,importe,interes
        FROM oldInversion);

DROP TABLE oldInversion;

SELECT * FROM USER_CATALOG;

SELECT * FROM prestFormalizado;
SELECT * FROM invFormalizada;
SELECT * FROM prestamo;
SELECT * FROM inversion;