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!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Sequence values (Max & Min)

Status
Not open for further replies.
GBall

GBall

Programmer
Joined
May 23, 2001
Messages
193
Location
GB
Hi,
I need to get the max and min values of a sequence.
We have manually used different ranges for various areas of an application and I need to get all records that have been added automatically.
Anyone any idea how I can do this ?
I'm using oracle Inprocserver within VBA.

thanks,
Graham

Regards,
Graham
 
Sort by date Sort by votes
Select the values from USER_SEQUENCES or ALL_SEQUENCES.
 
Upvote 0 Downvote
Works for me.
Thanks.

Regards,
Graham
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

Olutee360
  • Locked
  • Question Question
Group by using values in a range
Replies
4
Views
536
Olutee360
Olutee360
rk68
  • Locked
  • Question Question
SQL Loader -Field in data file exceeds max length
Replies
1
Views
654
rk68
rk68
rk68
  • Locked
  • Question Question
check for numeric value in varchar2 field & number validation
Replies
3
Views
342
rk68
rk68
Andrzejek
  • Locked
  • Question Question
Copy Sequences
Replies
6
Views
692
Beilstwh
Beilstwh
rk68
  • Locked
  • Question Question
using like clause with ampersand "&"
Replies
2
Views
265
Beilstwh
Beilstwh

Part and Inventory Search

Sponsor

Back
Top