FB
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
SQL Views and Materialized Views: The Complete Guide

SQL Views and Materialized Views: The Complete Guide

By the end of this article, you’ll know all about views, materialized views, how to create them, their advantages, and much more. Table of Contents Here’s what we will be covering in this guide. Click on any of the headings and it will take you to that section on this... Read more
SQL DISTINCT: The Complete Guide

SQL DISTINCT: The Complete Guide

The SQL DISTINCT keyword lets you find unique rows. By the end of this article, you’ll know how to use it, what it can do, and understand several different examples. What is SQL DISTINCT? DISTINCT is a keyword in SQL that allows you to show unique or distinct results.... Read more