Whats the purpose of using Nextval while creating the
sequence.
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 |
1)After defining value set we define list of values, I need to enter 1000 values with out entering manually, how will you do that? 2)what are the parameters we use in a concurrent program? 3)what is payroll processing? 4)In organization window after defining an organization and organization classification how to create a new item in the others button? 5)If there are 10 users, How to restrict the selected users not to access the forms?
What view would you use to look at the size of a data file?
Explain the difference between ARCHIVELOG mode and NOARCHIVELOG mode and the benefits and disadvantages to each.
When creating a user, what permissions must you grant to allow them to connect to the database?
WHAT ALL DIFFERENT OPTIONS PRESENT IN WEBI?
while creating requisitions i am unable to see the list of organisation can anyone help me out ?
1. What is PO rate variance gain and loss?
which gives Oracle R12 Financial training in delhi please give me answer its urgent?
What is chargeback invoice? How do we create it? : oracle accounts receivable
Is there any link between pr form(purchse requisition)and po form(purchase order)
Whats the purpose of using Nextval while creating the sequence.
I need a Technical evaluation between Oracle and SAP ? please do a need ful.