Oracle PL SQL interview question Difference between SQL LOADER and EXTERNAL TABLE
HTML-код
- Опубликовано: 4 окт 2024
- Oracle PL SQL interview question Difference between SQL LOADER and EXTERNAL TABLE
Click here to subscribe to my youtube channel / @sivaacademy
Oracle Interview questions and Answers at • oracle interview quest...
Oracle 18C New features at • Oracle 18C New Feature
Oracle 12C New features at • Oracle 12C New Feature...
Oracle PLSQL records and collections at • oracle plsql records a...
Thank you, Sir....
This is unimaginable..... You are choosing topics from the learners point of view....
Thank you, Sir....
Welcome bro
Very well. Thank you.
Welcome
Sir, I see that 18C new series, can you pls let us know which version of oracle is it (not for new features)
Thank you so much siva
Hi Siva. Ur videos are great. I have a query on this external table. When im trying to run the select query, im getting an error. Kup-04040: file mig_config.txt in ext_data_dir not found. Please help me.
Hi Siva, Thank you again.
Can you please make a video where the Analytical functions can be used in practical situations with different scenarios.
Regards,
Sujaa
Few of the videos I have posted in practical question series uses analytical function, more questions I will post as and when I got questions from subscribers
Your explanation are best
Thanks and welcome
Worth watching siva sir
Thank you
Hi Sir.... Similar to this difference... Please also make a video on different ways of logging.... Error logging... Scinarios of this logging requirements....
Thank you, Sir....
Sure, kindly stay tuned bro
Hi Siva , Can you please let me know how to validate input file data , like date validations example allow records greater than 01-jan-2020 . And only allow records which are having completed status . Please help me out
Hi Sir ,
Could you please tell me the real time scenario when we will go for sql loader or External table ?
@ur, hopefully this video will answer your question.
ruclips.net/video/Gx31qIvI7MQ/видео.html
if not, please let me know. I will clarify your doubts if any.
If we are handling huge data, external tables consumes more memory there by impacting the performance.
But external tables have parallel concept, there by breaking large volumes of data into small chunks to increase processing speed.
Nicely explained, thanks
You are welcome
Nice information.. thanks
Welcome
Hi Shiva,
Thank you for great learning stuff! Could you pls me with writing joins and complex query with a real-time scenario in a better way .
Please send me your queries to siva.k.academy@gmail.com
Hi Siva Sir,
can you please make vedio for pipeline table function ?
@mahendra, Sure, will post soon. since there are few pending requests, i will post this asap.Thanks,Siva
How can I skip header from multiple file for single external table?
How to reject all the records if there is a bad data in the infile
Can you please make videos on postgresql as well like this. Or like u made upgraded feature of oracle diff version, like that also u can compare oracle and postgresql and make... It will be very helpful, as everyone is moving towards postgresql
Sure, please stay tuned, will cover postgres also
@@SivaAcademy sure, thanks a lot
Hi,
I would like to know if the file to be inserted by the SQL loader needs to be at the host server or it could be anywhere, for instance, another host/computer. regards
SQL loader you can access anywere from client machine whereever sql client is installed.
however external tables will be accessed from the path of hostserver
I hope ,We can't perform DML in external loader .
Hi Siva,
I am getting below error while reading from external tables.
Date conversation cache disabled due to overflow (default size :1000)
Could you please advise?
Thanks & Regards,
Prashant
Did u got solution?
@@mrthrinadhrao No.
pls explain about awr report
Can you please explain difference between UNION AND JOIN?
Sure, please stay tuned
Can we have indexes or constraints on external tables?
No, external data is actually a file, thats outside of database
How to capture erros using sqlloader, suppose I have 100 records from csv file out of that 5 records not loaded into table due to some data validations, now how to present to client about 5 records. Is there automatic way of sqlloader?
Hi Ravindra, all the failed records will be available in bad files., this gets generated while loading the data, you can look into this video to know the basic details,
ruclips.net/video/PT0P_G5dcBY/видео.html
@@SivaAcademy Thank you siva, is there any to load the bad files data into oracle table for tracking purpose. I need to capture error number and error message in table from bad file to show it to client each time. Because next time when we run sqlloader, bad file will get overwritten with some other error.
2) I could see in your video value 1000$ showing invalid number in bad file, my expecting is there any way to remove these special characters in control file script to load 1000$ value smoothly in table column. I know rtrim will be possible however if special character is presented like this 100$0 then how will you insert, please guide. Thank you advance
How external table works for multiple files?
Will add in next set of videos please stay tuned
Bro this video was damaged please reupload videos.
Hi sir
Hi Siva, Thank you
Can you please make video on how to store data file in table using SQL loader
Welcome bro, please look into this video
ruclips.net/video/PT0P_G5dcBY/видео.html
@@SivaAcademy Thank you Siva garu.
I have learnt good SQL and plsql concepts by your videos
Thank you once again
Welcome bro
@@SivaAcademy How to store file name in table , I mean flat file name in table.
Is it possible to insert file name into table name using SQL loader?
How to create external file
its normal text file only, you just need to place in database sever, and need to create a directory object in database to point the location.