SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Sequence Number not Allowed in select clause

996818Mar 21 2013 — edited Mar 21 2013

Hi ,

SQL:

 select tran_seq.nextval,fee_acc,curr,
        sum(amount) over (partition by fee_acc,curr ) as amt
 from tran1
 order by fee_acc

error: Sequence Number not Allowed Here.

as per me the only solution is create a function to increment the sequence and use that in select clause.

i think oracle should allow this method. Please share your comments to resolve . thank you

Edited by: Raj,Infant on Mar 20, 2013 11:43 PM

This post has been answered by Purvesh K on Mar 21 2013

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on Apr 18 2013

Added on Mar 21 2013

4 comments

1,171 views