Whats the purpose of using Nextval while creating the
sequence.
- 2 Answers
- 7234 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 |
How I can load an image into image item on Forms. I want to know about built-ins and procedure. and also code for it.
WHAT ALL DIFFERENT KIND OF FUNCTIONS AVAILABLE WHILE DESIGN UNIVERSES?
Differentiate between transaction type and transaction source? : oracle accounts receivable
What is the difference between conversions and interfaces? : oracle accounts receivable
Describe the P2P cycle ?
What is the use of lockboxes? Steps for lock box : oracle accounts receivable
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
Explain about party and customer in ar : oracle accounts receivable
What is an Oracle database Full Backup?
while creating requisitions i am unable to see the list of organisation can anyone help me out ?
Is Oracle 7.3 is a single user or multi user..Is it possible to use this as a backend for web applications?
hi iam kavya, i completed Oracle11i(finance module), i do not know how to face the interview questions please adivese me
Oracle General 
