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;

What do you mean by Oracle MEDIA RECOVERY?

1229

---

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

1092

---

what are the tools used for oracle 10g in real time.

2442

---

Why more redos are generated when the oracle database is in begin backup mode?

1123

---

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

4446

---

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

1146

---

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

2188

---

difference of using cursor for loop and open,fetch,close.which one is better

1805

---

Can we modify approve purchase order?if yes what is navigation?

2010

---

Explain about party and customer in ar : oracle accounts receivable

1211

---

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

2318

---

My requirement is like in database some defects are present and i need to clean them.To be brief for example every employee should have active assigments.So for those records which are not having status as active or null ,i need to update the roecords using API with the correct value. Client will provide a flat file for the records whch are defected.So i need to run the API for those records (flat file)and update the data in database. So my question is how to handle this requirement.Is there any existing API for this purpose?If yes then please send me the NAME. How to update the records in the database using flatfile. Any pointer will be appreciated.Thanks in advance.

2201

---

can u pls share responsibilities for production how to environment in odi?and how to generate report ?

2402

---

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

2103

---

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

1266

---