select
		t.column_1 * (select <similar-non-trivial-query-using-column_1-and-literal_1>) as a_1,
		t.column_2 * (select <similar-non-trivial-query-using-column_2-and-literal_2>) as a_2,
		...
		t.column_N * (select <similar-non-trivial-query-using-column_N-and-literal_N>) as a_N
	from table_1 t

select
		t.column_1 * deterministic_function(t.column_1,literal_1) as a_1,
		t.column_2 * deterministic_function(t.column_2,literal_2) as a_2,
		...
		t.column_N * deterministic_function(t.column_N,literal_N) as a_N
	from table_1 t

select
		t.column_1 * (select regular_function(t.column_1,literal_1) from dual) as a_1,
		t.column_2 * (select regular_function(t.column_2,literal_2) from dual) as a_2,
		...
		t.column_N * (select regular_function(t.column_N,literal_N) from dual) as a_N
	from table_1 t

create table tmp$tab1(a number)
/
Table created.

begin
insert /*+WITH_PLSQL*/ into tmp$tab1(a)
with
function udf(p1 number) return number is begin return p1; end;
select udf(1) from dual;
end;
/
>> begin
insert /*+WITH_PLSQL*/ into tmp$tab1(a)
with
function udf(p1 number) return number is begin return p1; end;
select udf(1) from dual;
end;
Error at line 1
ORA-06550: Строка 4, столбец 10:
PL/SQL: ORA-00905: отсутствует ключевое слово
ORA-06550: Строка 2, столбец 1:
PL/SQL: SQL Statement ignored
ORA-06550: Строка 5, столбец 1:
PLS-00103: Встретился символ "SELECT"