I'm currently doing a project in oracle PL/SQL, I am somewhat new to this language, and I have a question:
If I try to do something like this:
select id
into id_aux
from clients
where name=name_input;
and if there are no clients with the name=name_input, what happens to id_aux?
Does it remain the same, is it set to NULL, is there any exception I can use?
I am asking this because I am thinking of using "id_aux" as a control variable.
We admitted we were powerless over dubs β that our lives had become unmanageable.
Came to believe that a Power greater than ourselves could restore us to sanity.
Made a decision to turn our will and our lives over to the care of God as we understood Him.
Made a searching and fearless moral inventory of ourselves.
Admitted to God, to ourselves, and to another human being the exact nature of our wrongs.
Were entirely ready to have God remove all these defects of character.
Humbly asked Him to forget all of our dubs.
Made a list of all persons we had harmed, and became willing to make amends to them all.
Made direct amends to such people wherever possible, except when to do so would injure them or others.
Continued to take personal inventory and when we were wrong promptly admitted it.
Sought through prayer and meditation to improve our conscious contact with God as we understood Him, praying only for knowledge of His will for us and the power to carry that out.
Having had a spiritual awakening as the result of these steps, we tried to carry this message to others, and to practice these principles in all our affairs.
>>1
Make sure then that you create the variable id_aux, and make either a switch or if else conditional to assign id_aux something than: Error id_aux not an assigned variable.