How to use the result of a query in a condition?

Question

Oracle

Good afternoon!
There is such request: select user from dual ;
in it I get the name of the current user. How can the result of this query be used for a subsequent query on the table? Those. for example, display all records from a table where the username matches the name in the table. The request to the table will be processed by means of RLS.

Answer 1

What's stopping you from doing so?

SELECT something FROM someTable as st 
INNER JOIN dual as d ON d.user = st.user AND d.user = 'someName'