Interested to Buy Any Domain ? << Click Here >> for more details...
Whats the purpose of using Nextval while creating the
sequence.
- 2 Answers
- 8013 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 TEMPLATES?EXPLAIN WHAT YOU HAVE CREATED?
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.
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.
I am Bsc Computer Science Graduate, I have good knowledge in SQL 7.0, Can I go for Oracle APPS course please suggest me the answer
What are the advantages of operating a database in ARCHIVELOG mode over operating it in NO ARCHIVELOG mode in Oracle?
what is the link between suppliers and banks in ap module in oracle apps? And also query?
how can it possibble to see the report output in excel sheet in oracle applications
which one is currently in used software cmpanies.
Explain accounting for invoice in advance and arrears. : oracle accounts receivable
Give two examples of how you might determine the structure of the table DEPT.
What does coalescing a tablespace do?
What is the Symbol use for Inner Join
Oracle General 
