Interested to Buy Any Domain ? << Click Here >> for more details...
Whats the purpose of using Nextval while creating the
sequence.
- 2 Answers
- 8029 Views
- HCL, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
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.
| Is This Answer Correct ? | 6 Yes | 2 No |
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;
| Is This Answer Correct ? | 2 Yes | 2 No |
which gives Oracle R12 Financial training in delhi please give me answer its urgent?
hi all, i have installed oracle xe software in windows 7. iam unable to connect sqldeveloper tool. can you please tell me how to connect. provide completed procedure.
TILL WHAT LEVEL OF SECURITY BO SUPPORTS?
Explain an ORA-01555
what are all the conversion and interfaces in GL,AP,AR,HRMS with example? otherwise send send link for these
0 Answers Pathway Technologies,
Explain the difference between ARCHIVELOG mode and NOARCHIVELOG mode and the benefits and disadvantages to each.
Differentiate between writeoff and receipt writeoff. : oracle accounts receivable
Explain the difference between a data block, an extent and a segment.
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.
Where would you look for errors from the database engine?
Hi, I want to know basic information about Oracle HRMS and the institutes in hyderabad or the best faculty as i want to make my career in it.And also want to know may a person from non technical background be able to do this course. Regards, Swetha
Can we modify approve purchase order?if yes what is navigation?
Oracle General 
