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 EXTEND method.
- 30 July 2022
- Database Performance ManagementManuals
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 EXISTS method.
In Oracle PL/SQL, the EXISTS method is a function that tells you if a specified Varray or Nested Tables element exists….
MySQL function indexes.
MySQL indexes: Starting with MySQL 5.7, you can create indexes for expressions, or functional indexes using the generated columns. Basically you need …
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!