Query MySQL from SQL Server using a linked server.
- 31 July 2022
- Database Performance ManagementSoftware Engineering
SQL Server has an interesting feature called Linked Servers. It is about linking other databases to SQL Server and using their data as local. There ar…
Oracle EXISTS method.
- 30 July 2022
- Database Performance Management
In Oracle PL/SQL, the EXISTS method is a function that tells you if a specified Varray or Nested Tables element exists….
Oracle EXTEND method.
In Oracle PL/SQL, the EXTEND method is a procedure that adds elements to the end of Varray or Nested Tables. The collection can be empty, but not NULL…
Oracle Nested Tables.
In Oracle PL/SQL Nested Tables is a column type that stores an unlimited row set in a certain order.
When you extract a nested table value from a dat…
Oracle MULTISET UNION.
- 28 July 2022
- Database Performance ManagementSoftware Engineering
In Oracle PL/SQL, the MULTISET UNION collection operation returns the merging of two collections…
The views expressed on this blog are those of the author and do not necessarily reflect the opinions of Enteros Inc. This blog may contain links to the content of third-party sites. By providing such links, Enteros Inc. does not adopt, guarantee, approve, or endorse the information, views, or products available on such sites.
Are you interested in writing for Enteros’ Blog? Please send us a pitch!