Oracle PL SQL interview question Difference between SQL LOADER and EXTERNAL TABLE

Oracle PL SQL interview question Difference between SQL LOADER and EXTERNAL TABLE

[gurumoorthysivakolunthu]

Thank you, Sir....
This is You are choosing topics from the learners point of view....
Thank you, Sir....

[imramesh]

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

[prashantsolanki]

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 .

[sujaa]

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

[ztech]

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

[sunithailapakurthy]

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.

[susmiboddu]

Sir, I see that 18C new series, can you pls let us know which version of oracle is it (not for new features)

[gurumoorthysivakolunthu]

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....

[rajue]

If we are handling huge data, external tables consumes more memory there by impacting the performance.

[mohinithor]

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

[ur]

Hi Sir,
Could you please tell me the real time scenario when we will go for sql loader or External table ?

[ravindrareddy]

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?

[mahendrasinghthakur]

Hi Siva Sir,
can you please make vedio for pipeline table function ?

[alokmishra]

How to reject all the records if there is a bad data in the infile

[prashantmate]

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

[riyankamondal]

How can I skip header from multiple file for single external table?

[Night_Fury_Gamer]

I hope, We can't perform DML in external loader .

[raginideshpande]

Can we have indexes or constraints on external tables?

[sampathkumar]

Can you please explain difference between UNION AND JOIN?

[narenderbabinolla]

Hi Siva, Thank you
Can you please make video on how to store data file in table using SQL loader