
	Home > Ask the Oracle Experts > Database Design and Architecture Questions & Answers > How to import comma-delimited text file to Oracle table

Ask The Oracle Expert: Questions & Answers

EMAIL THIS

How to import comma-delimited text file to Oracle table

EXPERT RESPONSE FROM: Brian Peasland

		Pose a Question

		Other Oracle Categories

		Meet all Oracle Experts
		Become an Expert for this site

Oracle tips, scripts, and expert advice

Digg This! StumbleUpon Del.icio.us

QUESTION POSED ON: 15 June 2007
I am a newbie for the Oracle platform; for the last five years we've been using SQL Server, and now we switched to Oracle. Coming to the point, we have an application in which we have to import a text file (delimited with commas) to an Oracle table via our application. Our application tool is PL/SQL. So is there any way to import a text file in Oracle via coding? Earlier we were using BCP (bulk insert utility) in SQL Server. Please suggest an alternative method. Thanks.

EXPERT RESPONSE

You already know about SQL Server's BCP utility. Oracle's similar utility is called SQL*Loader. SQL*Loader will load the contents of a text file into an Oracle table. Oracle extended this utility with something called External Tables. With External Tables, you can access a text file with SQL commands just as if it were an actual table. External Tables uses the SQL*Loader engine before passing the data to the SQL engine.

Click here for a document that details SQL*Loader and External Tables.

Digg This!

StumbleUpon

Del.icio.us

RELATED CONTENT

	Database Design and Architecture
	Why am I getting an Oracle error when issuing the RECOVER DATABASE command?
	Can I add multiple datafiles and make use of all the temporary datafiles at the same time?
	What's the best tape backup strategy for 10g RAC?
	Checkpoint vs. commit process
	How does an INSERT/UPDATE statement behave when executed compared to a SELECT statement?
	Can I resize the SYSTEM tablespace?
	What is the difference between an instance and mounting in Oracle?
	How to implement a ref cursor called in a stored procedure
	In Oracle, does the number of columns in a table affect the performance during SELECT/INSERT/UPDATE?
	Performance issues in Oracle 9i

Oracle PL/SQL

Oracle's free SQL Developer adds database migration tool

Confused about Oracle certification exams

ORA-01422 error when procedure returns more than one row

Calling procedure inside another procedure in anonymous block

Oracle updates Microsoft developer tools

PLS-00103 errors

PL/SQL do's and don't's: Five questions with Steven Feuerstein

Definition of force view

ORA-04082: NEW or OLD references not allowed in table level triggers

Oracle updates free Web development tool

Oracle data and application integration

Podcast: Oracle outlines AIA vision

Oracle's 10 steps to get to Fusion rely on Oracle investments

Oracle Fusion Middleware: Top five headlines

Oracle adds Data Integration Suite to middleware family

Oracle-BEA deal means tough choices for middleware buyers

Oracle to buy BEA Systems

Oracle adds Enterprise 2.0 to Fusion Middleware 11g

Oracle scoffs at BEA's buyout proposal

Oracle's Application Integration Architecture: An Oracle OpenWorld 2007 preview

Oracle bids for BEA Systems

RELATED GLOSSARY TERMS

Terms from Whatis.com − the technology online dictionary

PL/SQL (SearchOracle.com)

RELATED RESOURCES

2020software.com, trial software downloads for accounting software, ERP software, CRM software and business software systems

Search Bitpipe.com for the latest white papers and business webcasts

Whatis.com, the online computer dictionary

Search and Browse the Expert Answer Center
Search and browse more than 25,000 question and answer pairs from more than 250 TechTarget industry experts.

Browse our Expert Advice
Operating Systems IT Management Networking Database	Security Servers and Storage Applications and Development Career Center

SEARCH

TechTarget provides enterprise IT professionals with the information they need to perform their jobs - from developing strategy, to making cost-effective IT purchase decisions and managing their organizations' IT projects - with its network of technology-specific Web sites, events and magazines.


TechTarget Corporate Web Site \| Media Kits \| Reprints \| Site Map All Rights Reserved, Copyright 2003 - 2008, TechTarget \| Read our Privacy Policy