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

Does mysql support pl sql?

1175

How do we accept inputs from user during runtime?

1064

Explain the the delete statements in sql?

1063

What is sql used for?

1126

What is gpt format?

940

What is the difference between an inner join and an outer join?

1027

Can we join same table in sql?

1023

How do I truncate a word?

1090

what are the differences between procedure-oriented languages and object-oriented languages? : Sql dba

1047

Is it possible for a table to have more than one foreign key?

1030

How do you truncate?

906

How is pl sql different from sql?

1093

What are pl sql data types?

1012

What is the syntax and use of the coalesce function?

1175

What do you mean by query optimization?

1002