select sequencename.currval,sequencename.nextval from dual;

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

Question Posted / sweta

Answer Posted / sweta

Is This Answer Correct ?

0 Yes

2 No

Please Help Members By Posting Answers For Below Questions

What is error ora-12154: tns:could not resolve the connect identifier specified?

1015

What is benefit of creating memory optimized table?

906

What is a loop in sql?

935

How to use sql statements in pl/sql?

1052

What is the sql case statement?

950

Can I call a procedure inside a function?

944

How do I run a script in sql developer?

898

How to test for null values?

982

what are string data types? : Sql dba

971

what is the difference between join and union? : Sql dba

1027

What are the types of views in sql?

1038

What is a unique key?

1003

What is the difference between a subquery and a join?

1012

What is relationship? How many types of relationship are there?

1070

What is a full join?

911