FB
59 Best Resources for Learning SQL

59 Best Resources for Learning SQL

Are you looking for the best way to learn SQL? Are you unsure where to begin? The good news is that there are a lot of SQL tutorials online. There are many ways to learn SQL that are suitable for different people. Some people like reading articles or books, others... Read more
SQL Subqueries: The Complete Guide

SQL Subqueries: The Complete Guide

Subqueries are powerful features of SQL. If you want to move beyond the basics of SQL, then subqueries are something you need to know about. This article will show you everything you need to know about subqueries in SQL. What is a Subquery? A subquery is a SELECT... Read more
How to Install Oracle on a Mac

How to Install Oracle on a Mac

Installing an Oracle database on a Mac computer is a bit different to installing it on a Windows or Linux computer. If you’re running a MacBook (like I am), or any type of Mac, this article will be useful for you. You’ll see the step-by-step instructions to... Read more
ODC Appreciation Day 2018: Oracle Live SQL

ODC Appreciation Day 2018: Oracle Live SQL

ODC Appreciation Day is a roundup of blog posts by Oracle database blog owners on their favourite features of SQL Developer and other Oracle technologies. For this year, my appreciation is for Oracle Live SQL. Oracle Live SQL is a web-based tool that allows you to... Read more
Oracle SQL PIVOT and UNPIVOT: The Complete Guide

Oracle SQL PIVOT and UNPIVOT: The Complete Guide

Have you ever needed to convert a set of data from rows into columns? You can do this using the Oracle PIVOT feature (and the reverse using Oracle UNPIVOT). Table of Contents This guide covers the following topics. You can click on any of these entries to be taken to... Read more