Oracle SQL Loader - Introduction - Tutorial -1

[@ponnuenigma]

Great content! Waiting for 2nd part

[@sanjeevkumar9168]

Thank U for sharing Ur knowledge on SQL Loader

[@KishanMashru]

Sure Sanjeev, Hope you liked the video and subscribed to our channel!!!

[@ahmedtaufikzubair1556]

very nicely explained.

[@alexlim6300]

I dont understand. Do I need to download SQL loader? or is it something integrated into my pc already

[@traceyrawlings1270]

Where do I get the sql loader files from to load onto the windows client file

[@summiali3953]

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!

[@summiali3953]

Also,there are no any detailed video on External Tables concept on KZbin and considering how well you explain I want you to do a detailed video on this concept.

[@KishanMashru]

Sure, will create a video on that.

[@sachindixit6170]

Please tell the difference between SQL loader and UTL file package? Which one is better?

[@KishanMashru]

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.

[@UG008]

good explanation

[@KishanMashru]

Thanks Gaurav, If looking for any specific topic do let me know. :)

[@UG008]

Kishan Mashru yes sure 👍

[@elmokhliss4852]

Thanks

[@footballtv752]

Step by step written tutorial can be found here: numberblogs.blogspot.com/2020/04/oracle-sql-loader-hogyan-hasznaljuk-how.html