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 would you go about increasing the buffer cache hit ratio?

2593

---

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

2507

---

I need a Technical evaluation between Oracle and SAP ? please do a need ful.

1986

---

i am working with OC 4.5 i have numbers in table in 10 row with some null values please tell me how to find total? Thanks

2266

---

I am Bsc Computer Science Graduate, I have good knowledge in SQL 7.0, Can I go for Oracle APPS course please suggest me the answer

2257

---

What do you mean by Oracle MEDIA RECOVERY?

1217

---

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.

2190

---

How to move the data from one flatfile to multiple staging tables?give me some examples? for example in po interface one flat file is there and multiple staging tables are there how can move it?please give me answer for this question?

2404

---

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

1306

---

Explain the payment term in ar. : oracle accounts receivable

1101

---

A scenario for amount correction & how to use amount correction functionality in AP invoices

2128

---

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

1253

---

while creating requisitions i am unable to see the list of organisation can anyone help me out ?

2131

---

key flexfield structure

2166

---

What is the mandatory setup in cyclecount ?

2744

---