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;

A Table has 10,000 records,How can i get latest 10 dates from the table.so that i can only store those 10 records in to my Resultset Object,to reduce load on my app?

7 Answers   TCS,

---

Explain prerequisites and post activities of oracle database installation

0 Answers  

---

Describe what redo logs are.

1 Answers  

---

WHAT ALL DIFFERENT KIND OF FUNCTIONS AVAILABLE WHILE DESIGN UNIVERSES?

0 Answers  

---

What is cardinality?

4 Answers  

---

pl help me, i want oracle HRMS training institute address,in chennai

8 Answers  

---

what are all the conversion and interfaces in GL,AP,AR,HRMS with example? otherwise send send link for these

0 Answers   Pathway Technologies,

---

Differentiate between standard remittance and bills receivable remittance : oracle accounts receivable

0 Answers  

---

What Are Cross Validation & Adi?

0 Answers   Oracle,

---

Whats the purpose of using Nextval while creating the sequence.

2 Answers   HCL,

---

HOW TO SPOT AHIERARCHY?

0 Answers  

---

What is the Difference between the Person_Type_id column in the per_all_people_f and per_person_type_usages_f

0 Answers  

---