How can I convert the below SQL from MSSQL to Oracle.

select * from TEST_USER
where (UPPER(USER_ID) = UPPER(CAST(@USER_ID as varchar)) OR @USER_ID is null)


the @USER_ID is I want to have all of the records if it's NULL and matching records if not NUL.

thanks