lokeshRao

 Profile Answers by lokeshRao 

• Jun 23rd, 2008

 

select <seqname>.curvale from dual

srividhya_85

 Profile Answers by srividhya_85 Questions by srividhya_85

• Jun 24th, 2008

 

Select seq_name.curr_val from dual;

ravi.8311

 Profile Answers by ravi.8311 

• Jun 28th, 2008

 

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.

nandk.sharma

 Profile Answers by nandk.sharma 

• Jun 30th, 2008

 

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'

mstreete

 Profile Answers by mstreete 

• Sep 29th, 2008

 

If you don't own the sequence, you may look at all_sequences, which shows sequences in other schemas that you have access to:select max_valuefrom sys.all_sequenceswhere sequence_owner = '&sequence_owner' and sequence_name = '&sequence_name'