Return Styles: Pseud0ch, Terminal, Valhalla, NES, Geocities, Blue Moon. Entire thread

PL/SQL related question

Name: Anonymous 2013-04-05 22:04

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.

Newer Posts
Don't change these.
Name: Email:
Entire Thread Thread List