For 18c, you can also add a link to https://oracle-base.com/articles/18c/inline-external-tables-18c

Is there any new feature makes that one can use external tables whose file location is outside the db server?

Hi,

Around here the DBAs don't give CREATE DIRECTORY rights or any kind of access to the database server to users or applications. They cite mainly concerns about backup-scenarios in ExaData-RACs.
Unfortunately external tables cannot apparently be setup as READ ONLY. They always want at least some logging and it seems you can't completely disable bad/reject-handling either even if the files remain empty.
So I've been thinking it would be very cool if client tools (like sqlplus) could tunnel a client-local directory to the database server where it would appear like a DIRECTORY object (without CREATE DIRECTORY rights). From there you could use anything external tables have to offer including the way cool preprocessor feature. I can't offhand think of any security concerns compared to what sqlldr or sqlplus can already do.
Do you think Oracle has any plans to add such a feature in the future?

regards,

You could use a little shell scripting on client side to generate some sql codes.
Here is how.

$ cat file.csv
NIF
504594583
503640719
508327466
503361135
507685903
510204775
503142263
502309440
512004048
508597927
502303433
505306182

$ cat generate_sql.sh
awk 'BEGIN {printf "with client_selected as (\n";} { \
if (NR==1) {skip;} else \
if (NR==2) {printf "select %s client_id from dual\n", $1;} else \
{printf "union select %s client_id from dual\n", $1;}} \
END {printf ")\n";}'
cat <<EOF
select
tp.process_id
from
t_process tp
, client_selected cs
where
tp.client_id = cs.client_id
;
EOF

$ ./generate_sql.sh < file.csv > generated.sql

$ cat generated.sql
with client_selected as (
select 504594583 client_id from dual
union select 503640719 client_id from dual
union select 508327466 client_id from dual
union select 503361135 client_id from dual
union select 507685903 client_id from dual
union select 510204775 client_id from dual
union select 503142263 client_id from dual
union select 502309440 client_id from dual
union select 512004048 client_id from dual
union select 508597927 client_id from dual
union select 502303433 client_id from dual
union select 505306182 client_id from dual
)
select
tp.process_id
from
t_process tp
, client_selected cs
where
tp.client_id = cs.client_id
;

$