RubenQs's questions

I am doing a for loop in Oracle 10g, inside the loop I have a query, what I need is that if this query does not return anything or gives an error, jump to the next iteration without performing the following instructions.

      FOR I IN LTRN.FIRST .. LTRN.COUNT

        LOOP


    SELECT ID_CLIENTE

     INTO VID_CLIENT`introducir el código aquí`E

          FROM AAA_CLIENTES

              WHERE ID_PERSONA = LTRN(I).ID_PERSONA;

                    LTRN(I).ID_CLIENTE := VID_CLIENTE;

/*(Aquí debería ir el "exception" y dentro de este la opción para saltar a la siguiente iteracion del for, intente con Go To pero me generar error)*/


      END LOOP;

I hope you can help me.

I need to replace a particular character from each in oracle.

For example:

cadena= '12121113'

and what I need is to change the "1" to a "2" but only the "1" that is in position 3.

and return me the modified result.

As a result it should remain '12221113'.

I hope I have explained myself well.