Posts in: Databases

FETCH FIRST ROWS

Use FETCH FIRST syntax for limiting results in Oracle SQL, similar to LIMIT in other databases.

Read More →

DUAL Table and Sequences

Learn about Oracle's DUAL table for expressions and SEQUENCES for generating unique numbers.

Read More →

Flashback Queries

Use Oracle Flashback Query to retrieve data as it was at a past point in time.

Read More →

Getting Started with MySQL

Understand the role of MySQL in relational databases, how it works under the hood, and what makes it one of the most popular open-source RDBMS solutions in the world.

Read More →

Installing and Connecting to MySQL

Learn how to install MySQL on your machine and connect using the command-line interface and graphical tools like MySQL Workbench.

Read More →