Home » SQL & PL/SQL » SQL & PL/SQL » what is difference
what is difference [message #227815] Thu, 29 March 2007 08:35 Go to next message
Messages: 1
Registered: March 2007
Junior Member
what is difference between sqlldr and utl_file usage.
Re: what is difference [message #227816 is a reply to message #227815] Thu, 29 March 2007 08:40 Go to previous message
Messages: 381
Registered: September 2006
Location: UK
Senior Member
Another question: what is the difference between an expert and a novice ? You should have posted this in the newbies forum.

Sqlldr is a specialised utility for loading flat files into Oracle tables. UTL_FILE is used within PL/SQL to read and write flat files. SQLLDR will in general be faster to load data, especially if you use direct path mode.
Previous Topic: Hey Guro: Need Urgent Help on writing Query
Next Topic: String manipulations
Goto Forum:

Current Time: Fri Aug 18 07:43:17 CDT 2017

Total time taken to generate the page: 0.15575 seconds