Interested to Buy Any Domain ? << Click Here >> for more details...
Whats the purpose of using Nextval while creating the
sequence.
- 2 Answers
- 8023 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
i am working with OC 4.5 i have numbers in table in 10 row with some null values please tell me how to find total? Thanks
What is Restricted Mode of Instance Startup in Oracle?
Differentiate between earned discounts and unearned discounts? : oracle accounts receivable
how to replace not in with not exist?
How would you go about increasing the buffer cache hit ratio?
What are different types of receipt reversals ? Explain them : oracle accounts receivable
TILL WHAT LEVEL OF SECURITY BO SUPPORTS?
I would like to study certification course in Data base adminidtrator then where would i go to study this course?
what are the API of GL,PO,AP
What is the use of lockboxes? : oracle accounts receivable
Difference between transaction type and transaction sources. : oracle accounts receivable
HOW TO SAVE UNIVERSES AND DOCUMENTS IN THE REPOSITORY?
What are the advantages of operating a database in ARCHIVELOG mode over operating it in NO ARCHIVELOG mode in Oracle?
What is the meaning of "Modulus" and "Alignment" in a datafile. Data file might be from any database. Data file is created through unloading data from a table. So, while loading this data into my table, I need to use these keywords. Could any one can help me regarding this?
Differentiate between unidentified receipt, unapplied receipts and on account receipts? : oracle accounts receivable
