nextval from dual

[Stevenn]

I have the following code, but I don't know what it exactly means. It gives me the next 'available' unique upload_id I guess, but why is it called "UPLOAD_SEQ"? I've seen examples where it looked exactly like my code but with another name instead of UPLOAD_SEQ.

With objRecordset
    .Open "SELECT UPLOAD_SEQ.nextval FROM DUAL", objConnection
    sngUploadID = .Fields(0)
    .Close
End With

 

[Firefly2012]

Is that the field name ("UPLOAD_SEQ.nextval")? Can you see the actual field names within the database in table Dual?