<div>
Two main ways:<br />
<br />
1. Import the data into a table via SQL* Loader - <a href="http://www.orafaq.com/wiki/SQL*Loader_FAQ" rel="ugc">http://www.orafaq.com/wiki/SQL*Loader_FAQ</a><br />
<br />
2. Create an External Table which points to the file - <a href="http://www.orafaq.com/node/848" rel="ugc">http://www.orafaq.com/node/848</a>
</div>


Two main ways:

1. Import the data into a table via SQL* Loader - http://www.orafaq.com/wiki/SQL*Loader_FAQ [http://www.orafaq.com/wiki/SQL*Loader_FAQ]

2. Create an External Table which points to the file - http://www.orafaq.com/node/848 [http://www.orafaq.com/node/848]

<div>
Can I create a temp table using a .csv file?
</div>


Can I create a temp table using a .csv file?

<div>
Yes, either of those methods I linked to can achieve it. The first one moves the data into the database, the second one allows the database to read the data which stays in the file.
</div>


Yes, either of those methods I linked to can achieve it. The first one moves the data into the database, the second one allows the database to read the data which stays in the file.

<div>
They really don't create a 'temp' table. &nbsp;The only thing in Oracle that resembles a temp table is a Global Temporary Table and even those are persistent database objects (The stay around).<br />
<br />
I also want to point out that with external tables, the text file has to be on the database server. &nbsp;Using sql*loader the file can be anywhere.
</div>


They really don't create a 'temp' table.  The only thing in Oracle that resembles a temp table is a Global Temporary Table and even those are persistent database objects (The stay around).

I also want to point out that with external tables, the text file has to be on the database server.  Using sql*loader the file can be anywhere.

<div>
<div class="content wysiwyg-content">
I want to create a temporary table called TempSKUs using a comma delimited text file named <br />
&quot;TestData&quot; stored in C:\Test folder.<br />
<br />
I want to use the temporary table linked to tables from a database on a server.<br />
<br />
How can this be done?<br />
<br />
Thanks
</div>
</div>


I want to create a temporary table called TempSKUs using a comma delimited text file named 
"TestData" stored in C:\Test folder.

I want to use the temporary table linked to tables from a database on a server.

How can this be done?

Thanks

How can I do this?

Oracle is an object-relational database management system. It supports a large number of languages and application development frameworks. Its primary languages are SQL, PL/SQL and Java, but it also includes support for C and C++. Oracle also has its own enterprise modules and application server software.