Ques:- What is SQL*Loader?Difference between
Asked In :-
Pinnacleworks Infotech, Zentron Labs, Valued Epistemics, Ribbon Communications Inc, CodeCraft Technologies, ScriptsHub Technologies, i-exceed technology solutions, Stridely Solutions, I Logix infotech, Icon Resources,
Right Answer:
SQL*Loader is a utility provided by Oracle for loading data from external files into Oracle database tables. It allows for high-speed data loading and supports various data formats.
The difference between SQL*Loader and other data loading methods (like INSERT statements or external tables) is that SQL*Loader is specifically designed for bulk data loading, offering features like data transformation, error handling, and the ability to load data from multiple files efficiently.
SQL*Loader is a utility provided by Oracle for loading data from external files into Oracle database tables. It allows for high-speed data loading and supports various data formats.
The difference between SQL*Loader and other data loading methods (like INSERT statements or external tables) is that SQL*Loader is specifically designed for bulk data loading, offering features like data transformation, error handling, and the ability to load data from multiple files efficiently.