Oracle equivalent to SCOPE_IDENTITY()?

See more:

Oracle

Can some one verify my thinking here? Does this code return the correct Sequence Number as Inserted by my statement:

INSERT (myTablePrimaryKey, Field1, Field2)
VALUES (myTableSeqNo.NextVal, 'Data1', 'Data2')

Select myTableSeqNo.currval

Does this return the sequence number I inserted to the table and is it guaranteed to be mine in a busy environment with many users and inserts?

Thanks.