Code Forums - View Single Post - Beginning SQL sequences using PostgreSQL and Oracle

Sir R4T IV · 02-03-2004, 09:32 AM

This tutorial was very helpful. Thank you very much, jeffro.
but i'm sorry to say i'm still a novice in this area. i'd just like to know if like NEXTVAL, there are other functions or not.

My problem is, once i used NEXTVAL, what do i do to set the pointer back to the first values in the sequence? something like start value and endvalue must be there. If you could tell me the syntaxes, i'd be very grateful.

02-03-2004, 09:32 AM	#2 (permalink)
Sir R4T IV Registered User Join Date: Feb 2004 Posts: 6	Sql sequences This tutorial was very helpful. Thank you very much, jeffro. but i'm sorry to say i'm still a novice in this area. i'd just like to know if like NEXTVAL, there are other functions or not. My problem is, once i used NEXTVAL, what do i do to set the pointer back to the first values in the sequence? something like start value and endvalue must be there. If you could tell me the syntaxes, i'd be very grateful.