PL/SQL - Find Sequence MAX Value

GeekInterview.com > Tech FAQs > PL/SQL

Go To First | Previous Question | Next Question

PL/SQL | Question 137 of 140

Find Sequence MAX Value

How to find the max value in a Sequence?

Total Answers and Comments: 4

Last Update: June 30, 2008 Asked by: pc_mts

Sponsored Links

Best Rated Answer

—

No best answer available. Please pick the good answer available or submit your answer.

June 23, 2008 06:09:07

lokeshRao

Member Since: June 2008 Contribution: 0

RE: Find Sequence MAX Value

select <seqname>.curvale from dual

Is this answer useful? Yes | No

June 24, 2008 12:12:43

srividhya_85

Member Since: June 2008 Contribution: 0

RE: Find Sequence MAX Value

Select seq_name.curr_val from dual;

Is this answer useful? Yes | No

June 28, 2008 07:42:07

ravi.8311

Member Since: June 2008 Contribution: 4

RE: Find Sequence MAX Value

crete sequence<sequnce name)
increment by(no.val>
startwith<no. val>
max val<no.val>
cycle
cache);
suppose we give starting value 101 and give max value 1000,it t start at 101 and end with 1000 values.

Is this answer useful? Yes | No

June 30, 2008 03:04:02

nandk.sharma

Member Since: June 2008 Contribution: 2

RE: Find Sequence MAX Value

We can get the MAX value of a sequence by using the data dictionary view

'USER_SEQUENCES' .

i.e. SELECT MAX_VALUE FROM USER_SEQUENCES
WHERE SEQUENCE_NAME='NAME_OF_SEQUENCE'

Is this answer useful? Yes | No

Go To Top