sql | how NOT to avoid multiple identical subqueries in the SELECT clause

running 12c or higher? how to inline subqueries in SELECT clauses, or simply scalar subqueries, as you can guess by the name, is used to return a single value. but what if, i am having to query a specific table, writing identical subqueries to fet...