Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
reading sequence in Oracle
- Thread starter ceccina
- Start date
Hi,
Why? An Oracle sequence is ( usually) used to populate a field in a data table so why not read the field itself?
You could ( maybe) insert an Oracle function that reads
the Sequence_name.CurrVal and assigns it to a variable for use in your report, but I guess I do not see what you want to accomplish)
![[profile]](/data/assets/smilies/profile.gif "[profile] [profile]")
Why? An Oracle sequence is ( usually) used to populate a field in a data table so why not read the field itself?
You could ( maybe) insert an Oracle function that reads
the Sequence_name.CurrVal and assigns it to a variable for use in your report, but I guess I do not see what you want to accomplish)
- Status
Similar threads
- Locked
- Question
- Locked
- Question
- Locked
- Question