Answer / tharanath.n

NextVal is pseudo column, which gives you the unique number
in the sequence.
nextval increment the sequence and return new value.
currval can only be accessed in given session after at least
one nextval has been issued.

Answer / sreekanth

To get the next value of a sequence, we use nextval.


NextVal is pseudo column, which gives you the AVAILABLE
number in the sequence.
Remember the nextval value also depends on the cache you
have given, while creating the sequence.
If you want current value of a sequence you can use CurVal.
In a session you cannot use current value without getting
next value.
In 11g the you can use the nextval without using the query.
ie
select seq_name.nextval into ln_seqnextval from dual;
can be replaced by
ln_seqnextval := seq_name.nextval;

How can you enable a trace for a session?

2 Answers  

---

pl help me, i want oracle HRMS training institute address,in chennai

8 Answers  

---

can u give guidance abt packages of plsql

0 Answers   Mphasis,

---

what are all the conversion and interfaces in GL,AP,AR,HRMS with example? otherwise send send link for these

0 Answers   Pathway Technologies,

---

What is Restricted Mode of Instance Startup in Oracle?

0 Answers  

---

---

i am having comm in emp table and i want to display 0 when comm =null and -10 if comm= value

6 Answers   IBM,

---

Explain the use of table functions.

0 Answers  

---

Explain about party and customer in ar : oracle accounts receivable

0 Answers  

---

How would you force a log switch?

1 Answers  

---

how to write customizations in po

0 Answers   Ernst Young,

---

HOW TO SAVE UNIVERSES AND DOCUMENTS IN THE REPOSITORY?

0 Answers  

---

i am pursuing mca and i want to do oracle apps technical in hydrabad, plz guide me tne best institue in hydrabad those have excellent knowledge in oracle apps.

0 Answers  

---