Oracle：文件和表之间的内部联接(Oracle:inner join between file and table)

 我是oracle和plsql的新手，所以只需要忍受一下。 我有一个文件TYPES.txt ， 
 
id,name,values
1,aaa,32
2,bbb,23
3,cvv,12
4,fff,54
 
 我的数据库中还有一个表， PARTS.ATTRIBUTES 
 
id,name,props,crops
1,aaa,100,zzzz
2,bbb,200,yyyy
3,cvv,300,xxxx
4,fff,400,wwww
5,sasa,343,gfgg
6,uyuy,897,hhdf
 
 我想根据列name对文件TYPES和ATTRIBUTES进行INNER JOIN 。 现在，我通过最初将文件TYPES加载到临时表中，然后在临时表和ATTRIBUTES表之间进行INNER JOIN来完成此操作。 
 
 但我想知道是否有可能在TYPES文件和ATTRIBUTES表之间进行INNER JOIN而不使用临时表。 
 
 我知道我可以使用以下脚本加载文件并获取相应的行： 
 
declare
 file utl_file.file_type;
 line varchar2(500);
begin
 file :=utl_file.fopen('USER_DIR','TYPES.txt','r');
loop
 utl_file.get_line(file ,line);
 dbms_output.put_line(line);
end loop;
exception
 when others then
utl_file.fclose(file);
end;
 
 有人可以向我解释如何在文件内容和数据库表之间进行连接吗？ 
 
 PS TYPES.txt文件是动态生成的，并且在不同的时间可以有不同的列数。 

I'm new to oracle and plsql, so just bear with me. I have a file TYPES.txt,
 
id,name,values
1,aaa,32
2,bbb,23
3,cvv,12
4,fff,54
 
I also have a table in my db, PARTS.ATTRIBUTES
 
id,name,props,crops
1,aaa,100,zzzz
2,bbb,200,yyyy
3,cvv,300,xxxx
4,fff,400,wwww
5,sasa,343,gfgg
6,uyuy,897,hhdf
 
I'd like to do an INNER JOIN on the file TYPES and ATTRIBUTES based on the column name. Now, i have done this by initially loading file TYPES into a temp table and then doing INNER JOIN between the temp table and ATTRIBUTES table.
 
But i'd like to know whether it is possible to do INNER JOIN between TYPES file and ATTRIBUTES table without making use of a temp table.
 
I understand that i can load the file using and get respective rows using following script:
 
declare
 file utl_file.file_type;
 line varchar2(500);
begin
 file :=utl_file.fopen('USER_DIR','TYPES.txt','r');
loop
 utl_file.get_line(file ,line);
 dbms_output.put_line(line);
end loop;
exception
 when others then
utl_file.fclose(file);
end;
 
Could someone be kind enough to explain to me how i can do the join between file contents and the db table? 
 
P.S. The file TYPES.txt is dynamically generated and can have different number of columns at different times. 

原文：https://stackoverflow.com/questions/47391236