Interested to Buy Any Domain ? << Click Here >> for more details...
Whats the purpose of using Nextval while creating the
sequence.
- 2 Answers
- 7992 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 |
what are the tools used for oracle 10g in real time.
I need a Technical evaluation between Oracle and SAP ? please do a need ful.
What is the difference between a TEMPORARY tablespace and a PERMANENT tablespace?
What is an Oracle database Full Backup?
Explain accounting for invoice in advance and arrears. : oracle accounts receivable
Differentiate between standard remittance and bills receivable remittance : oracle accounts receivable
what are the types of LIST REPORTS in cognos8BI? and what is the mean and use of METRIC STUDIO in Cognos 8.3BI?
what is the link between suppliers and banks in ap module in oracle apps? And also query?
WHAT ALL DIFFERENT KIND OF FUNCTIONS AVAILABLE WHILE DESIGN UNIVERSES?
What is chargeback invoice? How do we create it? : oracle accounts receivable
What is the disk migration? what is the steps involved in oracle disk migration?
why r u using etl tool.
Oracle General 
