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

Is sql scripting language?

1040

Why do we use procedures in sql?

1068

What is composite data type in pl sql?

1090

What are its different types of dbms?

996

Can we use view in stored procedure?

889

How we can update the view?

1043

What is clustered index sql?

980

Mention what problem one might face while writing log information to a data-base table in pl/sql?

1221

Can you join views in sql?

947

Does view contain data?

1021

Which join is like inner join?

1012

What is database migration?

960

What trigger means?

969

What plvcmt and plvrb does in pl/sql?

1303

What is varchar example?

1022