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

How many developers work on postgresql?

1040

How do you update a value in sql?

1100

How do I partition a table in sql?

1202

What are different types of statements supported by sql?

1207

What is sql comments?

1116

what is the difference between delete and truncate statement in sql? : Sql dba

1344

what does myisamchk do? : Sql dba

1079

What is a dirty read sql?

1241

Compare sql & pl/sql

1209

explain the difference between myisam static and myisam dynamic. : Sql dba

988

How much does sqlite cost?

1094

Is there a 64 bit version of ssms?

997

How to call shell script from pl sql procedure?

1356

What is the difference between having clause and where clause?

1110

What is difference between pls_integer and integer?

1009