oracle pl/sql test

Sql code posted by abv
created at 16 Oct 11:19

Edit | Back 
1
2
3
4
5
6
7
8
9
10
11
12
 
declare
  some_value Number;
begin
  select test 
    into some_value 
    from some_table 
   where rownum = 1;
exception
  when no_data_found
    then null; -- sic!
end;
/
184 Bytes in 2 ms with coderay