Whats the purpose of using Nextval while creating the
sequence.
Answer Posted / 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 |
Post New Answer View All Answers
What is auto invoicing? : oracle accounts receivable
how to replace not in with not exist?
How to move the data from one flatfile to multiple staging tables?give me some examples? for example in po interface one flat file is there and multiple staging tables are there how can move it?please give me answer for this question?
WHAT ARE TEMPLATES?EXPLAIN WHAT YOU HAVE CREATED?
what are basic modules required to implement oracle application in any oraganisation?
Give two methods you could use to determine what DDL changes have been made.
what is difference between inner join & nested query or subqueries
can we use lexical perameter in oracle plsql if yes how
3. Steps in UAT?
Explain prerequisites and post activities of oracle database installation
Are These Dff's Flexible?
What is the mandatory setup in cyclecount ?
What is supporting issues GL AP and AR?
What is the difference between oracle media recovery and crash recovery?
What is mrc and what is its use? : oracle accounts receivable