Whats the purpose of using Nextval while creating the
sequence.
- 2 Answers
- 7352 Views
- HCL, I also Faced
- E-Mail Answers
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 are basic modules required to implement oracle application in any oraganisation?
Differentiate between earned discounts and unearned discounts? : oracle accounts receivable
Explain the payment term in ar. : oracle accounts receivable
How many segment are present in Oracle Manufacturing
Give two methods you could use to determine what DDL changes have been made.
What is the use of lockboxes? : oracle accounts receivable
what are the interface and api table for receipts conversion in oracle receivables? : oracle accounts receivable
What is auto accounting what are the steps for setting up auto accounting? : oracle accounts receivable
What is the use of transaction flexfield in autoinvoice? : oracle accounts receivable
What is Restricted Mode of Instance Startup in Oracle?
What is the importance of batch source set up in ar? : oracle accounts receivable
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 different types of receipt reversals ? Explain them : oracle accounts receivable
What are the different tools available for hot backups in Oracle? Is it preferable to take it manually all the time or it depends on the size of the database?
What view would you use to determine free space in a tablespace?
