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;

types of receipts and detail desription about recipts and tables effected by receipts?

0 Answers  

---

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

0 Answers  

---

can u tell me how many types of oracle and which type all detail in oracle (suppose all history of oracle )

1 Answers   IBM, Oracle,

---

What is Tax Categories?

0 Answers  

---

HOW TO SPOT AHIERARCHY?

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  

---

When creating a user, what permissions must you grant to allow them to connect to the database?

4 Answers  

---

PURCHASE ORDER TO PAYABLES WHAT ENTREIS WILL HAVE

0 Answers  

---

WHAT ALL DIFFERENT OPTIONS PRESENT IN WEBI?

0 Answers  

---

How would you go about increasing the buffer cache hit ratio?

0 Answers  

---

HOW TO GET THE ORGANIZATION TO ORGANIZATION DETAILS INFORMATION IN THE INVENTORY MODULE.THE REQUIREMENT IS FROMORG TOORG FROMINV TOINV ..

0 Answers   Infosys,

---

What are the main diff. between oracle 7.3 and oracle 8i?

1 Answers  

---