Answer / saty

select sequencename.currval from dual

select sequencename.nextval from dual



if we will give only table name thr will be error


Thanks & regards
satya
+919916174212

Answer / chandrasekar ramasamy

select sequencename.currval from tablename

select sequencename.nextval from tablename

Answer / shai

select *
from user_sequences;

The last_number column will display the number available
next.
if no_cache is used in sequence definition then you can
trust on last_number column from user_sequence.
But if cache is used then below will take place:

If Cache is 20 then last_number will display any number
within range of sequence currval+20

Answer / p.rajasekar

We cannot directly get Current value from the sequence.So
first we need to get the next value, then we can get the
current value in the same scope


select sequencename.nextval from tablename

select sequencename.currval from tablename

Answer / sweta

select sequencename.currval,sequencename.nextval from dual;

Answer / tulsi

select currval.sequence_name from table_name

select nextval.sequence_name from table_name

What is the difference between CHAR and VARCHAR2? If VARCHAR2 serves the uses of CHAR why CHAR is still used and not been discarded yet?

9 Answers   Oracle,

What is structural independence and why is it important?

0 Answers  

What is the difference between local and global temporary table?

0 Answers  

what is the difference between ereg_replace() and eregi_replace()? : Sql dba

0 Answers  

When you have to use a default "rollback to" savepoint of plvlog?

0 Answers  

How do I create an index in word?

0 Answers  

What does where 1/2 mean in sql?

0 Answers  

how can we repair a mysql table? : Sql dba

0 Answers  

What language is oracle sql developer?

0 Answers  

What are some predefined exceptions in pl/sql?

0 Answers  

What is rownum?

0 Answers  

how will i became good database developer?

1 Answers