Oracle Next Available Number

I have inherited a VERY old Mapics System running on Oracle8i Release 8.1.7.0.0 - Production

I need to know where I could look to find Current numbers, next available numbers and Max Number using PSQL on specific tables
Larry Bristersr. DeveloperAsked:
Who is Participating?

Improve company productivity with a Business Account.Sign Up

x
 
slightwv (䄆 Netminder)Connect With a Mentor Commented:
What numbers?

If the system is using Oracle Sequences you can get a list of them from the ALL_SEQUENECES view:
http://docs.oracle.com/cd/A87860_01/doc/server.817/a76961/ch273.htm#70966

Specifically the sequence_name, last_number and max_value columns.
0
 
Larry Bristersr. DeveloperAuthor Commented:
Perfect...
sys.all_sequences
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.