PL/SQL check if query returns empty

Question

I'm writing a procedure, and i need to check whether my select query returned an empty record or not. (In this example whether there is no x,y shelf)

How can i do that?

I tried this:

temp shelves.loadability%TYPE := NULL; BEGIN  select loadability into temp from shelves where rownumber = x and columnnumber = y; IF temp IS NOT NULL THEN /* do something when it's not empty */ ELSE /* do the other thing when it's empty */ END IF; 

But the second branch of the if never works...

EDIT:

Oh, it was so easy...

temp shelves.loadability%TYPE; BEGIN  select count(*) into temp from shelves where rownumber = x and columnnumber = y; IF temp != 0 THEN /* do something when it's not empty */ ELSE /* do the other thing when it's empty */ END IF;  END; 

Answer 1

Use an exception handler

Begin   select column   into variable   from table   where ...;    -- Do something with your variable  exception  when no_data_found then     -- Your query returned no rows --   when too_many_rows     -- Your query returned more than 1 row --  end;