Follow us: Connect on YouTube Connect on YouTube Connect on YouTube

Pages

Friday, 23 June 2017

Types of Exceptions in Oracle

Share this article :

1 comments:

  1. Hello Mate,


    The sense of praise that I have found for you after reading Types of Exceptions in Oracle is overwhelming! Such a tremendous read!

    i need help

    I have 3 tables, the first 2 tables already have values, this is the output

    SQL> select * from tblhorario
    2 ;

    IDHORARIO DESCRIPCIONHORARIO
    ---------- -----------------------
    1 L-V Oficina
    2 L-S Oficina
    3 L-S Extendido
    4 L-S Completo
    5 247

    SQL> select * from tblciudad;

    IDCIUDAD NOMBRECIUDAD
    ---------- -----------------------
    1 Bogota
    2 Cali
    3 Medellin
    4 Bucaramanga
    5 Cartagena
    6 Barranquilla
    7 Cucuta

    7 rows selected.

    For the thir table i need to insert data using a mix of sources:

    First from the normal keyboard input, and second a select query that brings me the fileds DESCRIPCIONHORARIO and NOMBRECIUDAD using the respective ID´S from the other 2 tables. I'm an student and i need help with this.

    This is the original query

    INSERT INTO tblLocal(nombreLocal, direccionLocal, telefono1Local, telefono2Local, celularLocal, emailLocal, renta, idHorario, idCiudad)
    VALUES('UTadeoLozano', 'Cra 5 calle 22', '2756456', 'N/A', '3107770900', 'lutadeo@printing.com', 675000, 1, 1);

    The last numerical values at the and of the clause are meant to come from the two original tables.

    If the solution is a trigger or a stored procedure, please help me.







    By the way do you have any YouTube videos, would love to watch it. I would like to connect you on LinkedIn, great to have experts like you in my connection (In case, if you don’t have any issues).


    Best Regards,
    Radhey

    ReplyDelete