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;

What is the difference between conversions and interfaces? : oracle accounts receivable

0 Answers  

---

What is an Oracle database Partial Backup?

0 Answers  

---

What type of index should you use on a fact table?

1 Answers  

---

what are important reports in HRMS,GL,AP,AR in oracle apps?

3 Answers   IBM, Pathway Technologies, Satyam, Techtimer, Wipro,

---

How do you use trigger to create mutating state of table

2 Answers   TCS,

---

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  

---

how to get the values if source table & target table having duplicate values that matches the lookup condition ?(i want all duplicate match)

1 Answers  

---

How would you determine what sessions are connected and what resources they are waiting for?

0 Answers  

---

Are These Dff's Flexible?

0 Answers   Oracle,

---

difference of using cursor for loop and open,fetch,close.which one is better

0 Answers   Accenture,

---

Explain the use of setting GLOBAL_NAMES equal to TRUE.

1 Answers  

---

What is Tax Categories?

0 Answers  

---