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

Does truncate require commit?

976

What is the maximum number of triggers, you can apply on a single table?

998

How many functions are there in sql?

1028

What is full form of rtm?

1008

How to display the current date in sql?

1078

What is update query?

984

What is trigger and stored procedure in sql?

1037

What is difference between nchar and nvarchar?

1028

how would you get the current date in mysql? : Sql dba

968

What is sql trigger example?

1067

What does count (*) do in sql?

1016

What are different types of indexes?

1011

What is scalar function in sql?

1041

How does left join work in sql?

1006

What is a system versioned table?

987