Record type in Oracle PL/SQL.
- 31 July 2022
- Database Performance ManagementMachine learning
Record type is a group of linked data elements stored in fields, each with its own name and data type. You can use Record as a variable, which may con…
Query MySQL from SQL Server using a linked server.
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…
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!