Interested to Buy Any Domain ? << Click Here >> for more details...
Whats the purpose of using Nextval while creating the
sequence.
- 2 Answers
- 8105 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
WHAT ALL DIFFERENT OPTIONS PRESENT IN WEBI?
What is the difference between conversions and interfaces? : oracle accounts receivable
can u give guidance abt packages of plsql
What is Restricted Mode of Instance Startup in Oracle?
we have 10 concurrent programs under one request group out of 10 ccps all users submitting only 9 programs from srs window remaining one ccp for specific user how can it possible send me answer asap.
key flexfield structure
What is autocashrule set? : oracle accounts receivable
1)After defining value set we define list of values, I need to enter 1000 values with out entering manually, how will you do that? 2)what are the parameters we use in a concurrent program? 3)what is payroll processing? 4)In organization window after defining an organization and organization classification how to create a new item in the others button? 5)If there are 10 users, How to restrict the selected users not to access the forms?
What is auto accounting what are the steps for setting up auto accounting? : oracle accounts receivable
How to clone the database using RMAN back
How do you create a credit note against an invoice? : oracle accounts receivable
3. Steps in UAT?
What are the standard concurent programs for auto invoice interface and customer interfaces? : oracle accounts receivable
A scenario for amount correction & how to use amount correction functionality in AP invoices
What is an Oracle database Partial Backup?
