Fraud Blocker

Machine Learning

In Oracle PL/SQL Associative Arrays, also known as index tables, which use arbitrary numbers and rows for index values.

Associative Arrays is a set …

Continue Reading

Oracle %TYPE attribute.

In Oracle PL/SQL, the %TYPE attribute for a variable provides the database column data type. This is especially useful when declaring variables that w…

Continue Reading

Oracle %ROWTYPE attribute.

In Oracle PL/SQL, the %ROWTYPE attribute provides a record type representing a string in the Oracle database table (or view).

A record may store an …

Continue Reading

Record type in Oracle PL/SQL.

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…

Continue Reading

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…

Continue Reading

🎉 Thank you for subscribing!

You're now on the list for database FinOps strategies and performance insights.