Whats the purpose of using Nextval while creating the
sequence.
- 2 Answers
- 7347 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 |
Hi, IN oracle apps HRMS, if the employee changes his department, and when a conconurrent program is run for calulating the pay, The latest Dept id is not diaplayed, howeber the previous deptid is considered. Please can someone tell me where is the program going wrong, which side?
what ASIS BUSINESS PROCESS IN ORACLE FINANCE
What is Tax Categories?
I would like to study certification course in Data base adminidtrator then where would i go to study this course?
How would you go about increasing the buffer cache hit ratio?
while creating requisitions i am unable to see the list of organisation can anyone help me out ?
What is autocashrule set? : oracle accounts receivable
Is Oracle 7.3 is a single user or multi user..Is it possible to use this as a backend for web applications?
How do you resize a data file?
What is the difference between a TEMPORARY tablespace and a PERMANENT tablespace?
I need a Technical evaluation between Oracle and SAP ? please do a need ful.
What are the mandatory setups in setting up a PO in oracle
Oracle General 
