top button
Flag Notify
    Connect to us
      Site Registration

Site Registration

How does one get the value of a sequence into a PL/SQL variable?

+1 vote
289 views
How does one get the value of a sequence into a PL/SQL variable?
posted Nov 24, 2014 by Archana

Share this question
Facebook Share Button Twitter Share Button LinkedIn Share Button

1 Answer

+1 vote
 
Best answer

Well, oracle doesn’t allow to assign a sequence value to a PL/SQL variable as
i := sq_sequence.NEXTVAL;(for some silly reason).

answer Nov 26, 2014 by Arun Gowda
...