Oracle Free SQL Overview

Written by Stephen Withrow.

See Oracle: Tips and Tricks for similar articles.

This article is a brief introduction to Oracle Free SQL (used to be Oracle Live). Oracle Free SQL is a great way to practice some basic read-only Oracle SQL without worrying about any set up or needing to pay for an account.

To try it out, follow these instructions:

  1. In your browser, go to https://freesql.com/.

  2. You will see the SQL Worksheet screen. Enter a query such as SELECT * FROM HR.COUNTRIES; (shown below) and then click the arrow icon in the left hand portion of the toolbar (highlighted in the image). The results of the query are displayed in the Query Result tab:
     

  3. In the Navigator panel, you can see a list of the tables in the HR schema. You can also explore the other schemas that Oracle has made available in the schema dropdown.
  4. Explore these tables and practice your Oracle SQL skills including joins! Note that you will not be able to change the tables or delete records.