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 the technical flow associated with P2P or Procure to Pay cycle like the tables, APIs, concurrent programs involved in this cycle. Only technical please.
Differentiate between unidentified receipt, unapplied receipts and on account receipts? : oracle accounts receivable
Differentiate between transaction type and transaction source? : oracle accounts receivable
can u pls share responsibilities for production how to environment in odi?and how to generate report ?
My requirement is like in database some defects are present and i need to clean them.To be brief for example every employee should have active assigments.So for those records which are not having status as active or null ,i need to update the roecords using API with the correct value. Client will provide a flat file for the records whch are defected.So i need to run the API for those records (flat file)and update the data in database. So my question is how to handle this requirement.Is there any existing API for this purpose?If yes then please send me the NAME. How to update the records in the database using flatfile. Any pointer will be appreciated.Thanks in advance.
how can we add a field to the oracle standard forms through Form Persanlization or custom.pll
What is db_recovery_file_dest in oracle? When do you need to set this value?
Could you please let me know the interfaces in OM / FA??
I need a Technical evaluation between Oracle and SAP ? please do a need ful.
What are the advantages of operating a database in ARCHIVELOG mode over operating it in NO ARCHIVELOG mode in Oracle?
IS IT POSSIBLE TO CREATE REPORTS FROM DIFFERENT UNIVERSES IN ONE DOCUMENT?
Can we modify approve purchase order?if yes what is navigation?
Difference between negative and positive adjustments : oracle accounts receivable
What is auto accounting what are the steps for setting up auto accounting? : oracle accounts receivable
What is Restricted Mode of Instance Startup in Oracle?