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.

Report message to a moderator

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.

Report message to a moderator

Previous Topic: Hey Guro: Need Urgent Help on writing Query
Next Topic: String manipulations
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Dec 06 13:44:07 CST 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.