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 a pragma statement?

1200

Is pl sql a scripting language?

969

What is data manipulation language?

1134

Can %notfound return null after a fetch?

999

Explain what is a view?

997

Can we use update in sql function?

1006

What is equi join in sql?

1008

What is a database trigger?

1017

what is the difference between primary key and unique key? : Sql dba

969

Is it possible to create startup or shutdown trigger for on-schema?

979

Explain the purpose of %type and %rowtype data types with the example?

925

What are the three forms of normalization?

993

what is a foreign key ? : Sql dba

1026

Why sql query is slow?

929

what are all types of user defined functions? : Sql dba

996