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

how to escape special characters in sql statements? : Sql dba

1028

Can we use delete in merge statement?

1033

How do I find duplicates in two columns?

1152

What is AUTH_ID and AUTH_USER in pl/sql ?

2180

How does a trigger work?

1058

What is trigger in sql and its types?

1053

What is a design view?

920

What is the clause we need to add in function body to return variable?

1007

What are commit, rollback, and savepoint?

982

Is coalesce faster than isnull?

962

Is left join same as inner join?

1110

How do I order columns in sql?

983

How to call shell script from pl sql procedure?

1266

What is oracle sql called?

916

what is a database transaction? : Sql dba

1164