select currval.sequence_name from table_name select nextval.sequence

How to access the current value and next value from a
sequence?

Question Posted / tulsi

Answer Posted / tulsi

select currval.sequence_name from table_name

select nextval.sequence_name from table_name

Is This Answer Correct ?

0 Yes

9 No

Please Help Members By Posting Answers For Below Questions

What is clause?

1063

what is a constraint? Tell me about its various levels. : Sql dba

929

Can we rollback after truncate?

980

describe transaction-safe table types in mysql : sql dba

943

Can we use update in sql function?

1006

What happens when a trigger is associated to a view?

840

What is sql trigger example?

997

what is a stored procedure? : Sql dba

1052

How do I clear the screen in sql plus?

982

What is set serveroutput on?

1087

what is an extent ? : Sql dba

1017

What is the mutating table and constraining table?

966

What is the difference between subquery and correlated query?

989

Does oracle use sql?

877

Is inner join same as self join?

1060