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

What is data control language (dcl)?

1147

What is a database trigger?

1073

What is sp_helptext?

1071

Are sql database names case sensitive?

1010

Differentiate between sga and pga.

1168

Explain the savepoint statement.

1102

What is sql rowcount?

1033

Does sql require a server?

1019

What are the two virtual tables available at the time of database trigger execution?

1227

What is the reports view in oracle sql developer?

998

What is a composite primary key?

1099

Is truncate ddl or dml?

997

how to create a new table by selecting rows from another table in mysql? : Sql dba

1113

how to convert numeric values to character strings? : Sql dba

1112

how many triggers are allowed in mysql table? : Sql dba

1074