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;

HOW TO SAVE UNIVERSES AND DOCUMENTS IN THE REPOSITORY?

2026

---

3. Steps in UAT?

2379

---

how to replace not in with not exist?

3676

---

Explain how to close periods in ar. : oracle accounts receivable

1248

---

WHAT ARE TEMPLATES?EXPLAIN WHAT YOU HAVE CREATED?

1977

---

default triggers available for reports

2166

---

What are the advantages of operating a database in ARCHIVELOG mode over operating it in NO ARCHIVELOG mode in Oracle?

1086

---

TILL WHAT LEVEL OF SECURITY BO SUPPORTS?

3500

---

How would you determine who has added a row to a table?

2262

---

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

2030

---

What is auto invoicing? Explain : oracle accounts receivable

1066

---

Are These Dff's Flexible?

1128

---

what is semphore explian it?

2762

---

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

1252

---

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

1116

---