Answer Posted / 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;

Explain the process of recievables in oracle financials. : oracle accounts receivable

664

---

what are the API of GL,PO,AP

1783

---

3. Steps in UAT?

1957

---

What is the importance of batch source set up in ar? : oracle accounts receivable

725

---

please send me oracle pl/sql exp resume. and also faqs...

2043

---

---

what is difference between inner join & nested query or subqueries

2492

---

What is an Oracle database Partial Backup?

705

---

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

1997

---

as a technical developer in oracle applications which type errors feced in your experience sofar

1915

---

HOW TO SAVE UNIVERSES AND DOCUMENTS IN THE REPOSITORY?

1595

---

key flexfield structure

1609

---

Hi, I want to know basic information about Oracle HRMS and the institutes in hyderabad or the best faculty as i want to make my career in it.And also want to know may a person from non technical background be able to do this course. Regards, Swetha

1963

---

default triggers available for reports

1765

---

What is the use of transaction flexfield in autoinvoice? : oracle accounts receivable

698

---

how can we add a field to the oracle standard forms through Form Persanlization or custom.pll

1918

---