HomeЛюди и блогиRelated VideosMore From: amit wadbude

SQL Loader: Uploading files in Oracle database

75 ratings | 10887 views
This video will give you brief introduction, video covers importance of SQL Loader, Component of SQL Loader and Practical scenarios, which will be helpful for uploading activity using SQL Loader.
Html code for embedding videos on your blog
Text Comments (25)
Rajesh Kumar (5 months ago)
Nice video. Just wanted to know how we can hide the password in control file and if we can use sequence value for id instead of id+ 999
sanjay s (1 year ago)
nice explanation watch more information https://www.sakthidbtech.com/blog/view/oralce-sql-loader
Bhaskar P (1 year ago)
Hi Amir, I have data in excel file. But here the problem is, i have different sheets in same file. Every sheet have different columns. Can u suggest how to upload different sheets to different tables.
amit wadbude (1 year ago)
Bhaskar P hi bhaskar, as we know sql loader works for delimited data and files, and in case of excel file, only csv file is supported, so if there is need to upload multiple sheets of excel then you need to first create separate csv file for each sheet and after that mentioned each csv file name into control file, conclusion is: multiple sheet of excel is not supported by sql loader. thanks for watching my video. keep in touch. have a nice day.
Satish Bagali (1 year ago)
Thanks Buddy. I took help from your video.
Kulamani Muduli (1 year ago)
how to handle null values if they come in between[not in the trailing part of record(in the last column)].. for emp table example: 7839,KING,PRESIDENT,,17-Nov-81,5000,,10 is OK.. but 7839,KING,PRESIDENT,null,17-Nov-81,5000,null,10 doesn't load in the table.. please help.
Kulamani Muduli (1 year ago)
Thanks for explaining.. I tried it specifying null. Eventually I got to know I shouldn't have put null keyword. Your response is truly appreciated nevertheless..👍👍
whatever fields you have defined in your control file. Your fields are terminated by a comma, so you do not need to specify any specific handler, commas in each record will automatically accept the NULL values for your fields unless TRAILING NULLCOLS is specified, even though if you are loading the ID field with a sequence value via the SQL String. Thanks
Kashif Khan (1 year ago)
American teacher would have finished same knowledge in 6 mins at max, indians are horrible in English but i trust their knowledge
Bibhuti Bhusan Nayak (1 year ago)
Nice explanation..but sir i have one doubt tht....if i ve a 1000 records but i wan to insert only 500 among of those record .so please guide me how to insert limited records..
amit wadbude (1 year ago)
SQLLDR CONTROL=E:\Scripts\recshtdata.ctl, LOG=E:\Scripts\recshtdata.log, BAD=E:\Scripts\recshtdata.bad, DATA=E:\Scripts\recshtdata.dat USERID=dbowner/[email protected], ERRORS=999, LOAD=2000, DISCARD=E:\Scripts\recshtdata.dis,DISCARDMAX=5 in above mentioned command LOAD statement is written, which will load first 2000 records.
Bibhuti Bhusan Nayak (1 year ago)
as i am a beginner so would u pls tell me where we have to declare load clause . whether it is from starting of the control file or else end of the control file
amit wadbude (1 year ago)
Thanks for your comment, and answer of your question is LOAD clause, by mentioning LOAD you can instruct to sql loader that how many row you want to access, i.e. LOAD=2000, in this case sql loader will access first 2000 rows. Please subscribe my channel for watching my upcoming videos. :)
santosh kumar (1 year ago)
Nice explanation..Thank You
amit wadbude (1 year ago)
Please subscribe my channel for more interesting videos.
Sai Krishna K (1 year ago)
Hai Amit, nice video about Sql loader good keep it up.but my doubt is y we are using other than utl file package ,external tables. can u pls explain y we are going to this ,and upload the videos for utl and external tables ,and difference of those. i hope to u understand my question.
Sai Krishna K (1 year ago)
amit wadbude ;)tq
amit wadbude (1 year ago)
Hi, firstly thanks for your comment. now come to your question. yes of-course there is a difference between sql loader and utl/external table, sql loader is a facility provided by oracle to load physical files i.e. files which resides in hard drive, for sql loader no need of oracle environment, here oracle environment means SQL console/plsql developer/TOAD etc, only batch file is sufficient to load data, so if you want you provide data loading functionality to client then you don't need to bother , simply provide batch file to client, client will execute batch file and task would be accomplished whereas utl and external table is oracle concept and this can't be used outside Oracle environment. other difference is sql loader is much much faster than utl/external table. I hope above explanation would be sufficient, pls feel free to comment. Thanks
Saravanan Manicka (2 years ago)
Nice Video and able to understand clearly for candidates like me having less knowledge in Technical. As mentioned by JSM, please add video of loading sample data in to target table.
amit wadbude (2 years ago)
Sure, I will do my best and in future video i will keep your feedback in mind. thanks for your valuable feedback, keep commenting. this means alot for me. :)
Mani Maddu (2 years ago)
nice but for me very difficulty.
amit wadbude (2 years ago)
I will try my level best to improve my skill so that further video can be more easy to understand, Thanks for your feedback, Keep commenting, your feedback is very important for me. :)
JSM (2 years ago)
Nice video .. good understanding , i think at last you should have done one import operation with some sample data to the target table. it could have been more informative to the viewers. any way conceptually this one very good. Thanks keep posting videos like this .
Mahesh Chaudhari (2 years ago)
Good Explanations...Thanks..
amit wadbude (2 years ago)
Thanks for watching my video, please share your feedback. let me know the area and topics which can be included in this channel.

Would you like to comment?

Join YouTube for a free account, or sign in if you are already a member.