Database Administration (MOSC)

MOSC Banner

SELECT NEXTVALUE FROM v$sequences

edited Oct 22, 2012 4:46AM in Database Administration (MOSC) 7 commentsAnswered
Hi Guys,

Do you know why after the database shutdown and startup if I run the following sql for an existing sequence, it ruturns NULL

  SELECT NEXTVALUE FROM v$sequences WHERE SEQUENCE_NAME='SEQUENCE_NAME';

But if I run first "select SEQUENCE_NAME.nextval from dual;and then run the above  it ruturns correct value.

Thanks for your help,

Majid

PS- The sequence has been created with CASH option.

 

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center