select sequencename.currval from tablename select sequencename.nextval f

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

Question Posted / chandrasekar ramasamy

Answer Posted / chandrasekar ramasamy

select sequencename.currval from tablename

select sequencename.nextval from tablename

Is This Answer Correct ?

8 Yes

3 No

Please Help Members By Posting Answers For Below Questions

Which command is used to delete a package?

1234

How to test for null values?

1098

How do I make my sql query run faster?

1016

How does cross join work?

1008

What do you understand by pl/sql records?

1062

What is rowtype?

1079

list out some tools through which we can draw e-r diagrams for mysql. : Sql dba

1017

difference between anonymous blocks and sub-programs.

1188

What is a sql trace file?

1085

Explain about various levels of constraint.

1000

How do you write an inner join query?

996

What is union?

1250

What is difference between cursor and trigger?

1129

What is pragma in sql?

1127

How to execute a stored procedure?

1156