Whats the purpose of using Nextval while creating the
sequence.
- 2 Answers
- 6978 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
now iam working as an hr executive in hyderabad i would like to learn oracle hrms kindly suggest me some good institutes in hyderabd
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
QUESTION IS THAT DURING UPLOADING DATA IN PROD SERVER,OUR EQUIPMENT TAG NUMBERS ARE NOT MATCHING WITH SAP TAG NUMBERS SO DUE TO THIS WE ARE FACING PROB, BECAUSE WHENEVER ALARM IS COMING FROM SCADA DUE MISMATCH THE NOTIFICATION IS NOT CREATED IT IS GIVING ERROR. PLEASE SUGGEST THE METHOD SO THAT THE TAG NUMBERS OF BOTH (SCADA EQUIPMENT AND SAP EQUIP) SHOULD CONCIDE.OTHERWISE WE HAVE TO GO FOR LONG PROCESS EITHER BY INTERFACE TABLE OR BY EXPORTING ALL DATA AND MAKING RIGHT CHANGES.DO YOU HAVE ANY SHORTCT METHOD PL WRITE ME. THANKS
Explain about party and customer in ar : oracle accounts receivable
What is an Oracle database Full Backup?
types of receipts and detail desription about recipts and tables effected by receipts?
how to replace not in with not exist?
What view would you use to determine free space in a tablespace?
What is supporting issues GL AP and AR?
difference of using cursor for loop and open,fetch,close.which one is better
What are the interface tables used for ar invoices, customers, receipts for conversion process? : oracle accounts receivable
Difference between transaction type and transaction sources. : oracle accounts receivable
where the dff data will be stored
what is semphore explian it?
Which is the best institute in Hyderabad to learn OBIEE and DataStage?Please tell me faculty name also
