SQL Transaction related

Hi,

I have a transaction like following:

BEGIN

     INSERT INTO tbl_xyz VALUES (val1, val2);
   
    SELECT INTO wid MAX(val1) FROM tbl_xyz;

END;

My question is in the SELECT INTO statement, will I get the value of val1 from the INSERT INTO in the same transaction
even though the transaction has not ended yet.
I think no.
How would I get that latest value of val1 in the same transaction because its not committed yet as the transaction has not ended.

Thanks,

~Harpreeet