They both are very much different from each other. UTL_FILE package helps you to read,write files, and much more say as creating reports etc.. SQL LOADER helps you to bulk load data in a file(in a specific format) into the database tables. You want to write sophisticated procedure using UTL_FILE that would help you to read from the files and load into database, sure why not!!! But who wants to do that when Oracle already provided it with SQL*Loader. Also as I mentioned in the video with SQL Loader the file can be in any client machine, whereas in case of UTL pkg, the file should be in the same system, where the database is, or else it won't be able to read / write. Surely Loader would be better than utl_file pkg.
Also,there are no any detailed video on External Tables concept on RUclips and considering how well you explain I want you to do a detailed video on this concept.
very nicely explained.
Great content! Waiting for 2nd part
Thank U for sharing Ur knowledge on SQL Loader
Sure Sanjeev, Hope you liked the video and subscribed to our channel!!!
I dont understand. Do I need to download SQL loader? or is it something integrated into my pc already
good explanation
Thanks Gaurav, If looking for any specific topic do let me know. :)
Kishan Mashru yes sure 👍
Where do I get the sql loader files from to load onto the windows client file
Please tell the difference between SQL loader and UTL file package?
Which one is better?
They both are very much different from each other.
UTL_FILE package helps you to read,write files, and much more say as creating reports etc..
SQL LOADER helps you to bulk load data in a file(in a specific format) into the database tables.
You want to write sophisticated procedure using UTL_FILE that would help you to read from the files and load into database, sure why not!!! But who wants to do that when Oracle already provided it with SQL*Loader.
Also as I mentioned in the video with SQL Loader the file can be in any client machine, whereas in case of UTL pkg, the file should be in the same system, where the database is, or else it won't be able to read / write.
Surely Loader would be better than utl_file pkg.
Hi Kishan,thanks for this video! Can you please let me know what are external tables and how SQL loader is different from external tables? Thanks!
Also,there are no any detailed video on External Tables concept on RUclips and considering how well you explain I want you to do a detailed video on this concept.
Sure, will create a video on that.
Thanks
Step by step written tutorial can be found here: numberblogs.blogspot.com/2020/04/oracle-sql-loader-hogyan-hasznaljuk-how.html