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 auto invoicing? : oracle accounts receivable

0 Answers  

---

What is difference b/w Credit memo and Adjustment in AR.

1 Answers   Oracle,

---

Give the stages of instance startup to a usable state where normal users may access it.

1 Answers  

---

Explain how to account for bank charges deducted from amount received against an invoice. : oracle accounts receivable

0 Answers  

---

Explain accounting for invoice in advance and arrears. : oracle accounts receivable

0 Answers  

---

what are the advantages of Oracle over other databases..? please give me reply...

2 Answers  

---

1.In a table Gender is a column in that male and female are the two data.In a single statement i have to modify all male to female and all female to male vice versa. 2.In a single query i need the count of male data,count of female and total count

3 Answers   HP,

---

Give the reasoning behind using an index.

2 Answers  

---

what are the API of GL,PO,AP

0 Answers  

---

What do you mean by hz_ in customer tables? : oracle accounts receivable

0 Answers  

---

What Are Cross Validation & Adi?

0 Answers   Oracle,

---

Explain materialized views and how they are used.

2 Answers  

---