Whats the purpose of using Nextval while creating the
sequence.
- 2 Answers
- 7380 Views
- HCL, I also Faced
- E-Mail Answers
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;
| Is This Answer Correct ? | 2 Yes | 2 No |
Post New Answer View All Answers
How many segment are present in Oracle Manufacturing
A scenario for amount correction & how to use amount correction functionality in AP invoices
What is auto invoicing? Explain : oracle accounts receivable
How would you go about increasing the buffer cache hit ratio?
Which is the best institute in Hyderabad to learn OBIEE and DataStage?Please tell me faculty name also
what ASIS BUSINESS PROCESS IN ORACLE FINANCE
where the dff data will be stored
WHAT ALL DIFFERENT OPTIONS PRESENT IN WEBI?
Explain the process of recievables in oracle financials. : oracle accounts receivable
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.
I've got a database 10g and Form version 5.0 but unable to connect. Does Oracle 10g database supports form 4.5
What is the disk migration? what is the steps involved in oracle disk migration?
I need a Technical evaluation between Oracle and SAP ? please do a need ful.
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?
what is difference between inner join & nested query or subqueries
