In the article we will see a magical way so that we can use in select queries data from external sources (without Linked Server) and more specifically from Oracle Database. What is PolyBase As of SQL Server 2016 the… read more
How do we load files (csv, txt) into Oracle database
It is possible to import files like csv and txt into an oracle database table. There are two similar ways. Using SQL*Loader or using External Table. Their mode of operation is similar, but depending on the case, it is more suitable... read more