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
suryag
Messages: 1
Registered: March 2007
Junior Member
Hai
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
Cthulhu
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 Dec 02 18:51:37 CST 2016

Total time taken to generate the page: 0.58473 seconds