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

Explain 3 basic parts of a trigger.

0 Answers  

how tsql statements can be written and submitted to the database engine? : Transact sql

0 Answers  

How to display the contents of a current record fetched in a reference cursor?

2 Answers  

How to write a query to show the details of a student from students table whose

0 Answers  

how many triggers are allowed in mysql table? : Sql dba

0 Answers  

What will you get by the cursor attribute sql%notfound?

0 Answers  

What is pl/sql table? Why it is used?

0 Answers  

Name some usages of database trigger?

0 Answers  

What are the disadvantages of file system?

0 Answers  

What is sql query limit?

0 Answers  

What is program debugging?

0 Answers  

why we go for package? what are the advantages of using instead of seperate procuderes or functions

3 Answers   IBM, TCS,