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 are user defined functions?

1063

What sql database should I use?

1192

What jobs use sql?

1031

What is t-sql? : Transact sql

1040

What is the source code of a program?

1118

What is basic structure of pl sql?

1130

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

1052

how to include comments in sql statements? : Sql dba

999

Which are the different types of indexes in sql?

1099

What are the sql commands?

1229

What is rename command in sql?

1093

Where can I learn sql for free?

1046

What is a crud api?

991

Define implicit and explicit cursors.

1206

What is before and after trigger?

1010