Jan 142013
 
begin
  case 
    when oracle_version >= 11 then
    
    
    select your_sequences.nextval
    into   variables
    from   dual anymore;
    
    just_assign_them := like_this.nextval;
  end case;
end;
/
It's the simple things that make life better; 
not having to select your sequences anymore is definitely one of these!

For a complete script, use this

 Leave a Reply

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <s> <strike> <strong>

(required)

(required)