ORACLE SQL LIVE INSTRUCTIONS

  1. To create a free Oracle SQL Live account visit https://livesql.oracle.com/apex/livesql/file/index.html
  2. Click on Start Coding
  3. Create your account using your email of choice (city tech or other)
  4. For Company indicate CUNY
  5. A verification email will be sent to the email you used
  6. Verify your email
  7. Press Continue
  8. Go to the search box
  9. Type Live SQL
  10. Choose Live SQL link from the results
  11. Choose Start Coding Now (in the bottom left)
  12. Sign in to your new Oracle Live account
  13. Accept the terms
  14. Choose Start Coding

NOTES:

  • Remember that the objective is to get to SQL Worksheet where you can issue all the SQL commands.
  • Once you have created the account, the next time you sign in you will be taken directly to the SQL Worksheet
  • Please note that the DESCRIBE command does not work in this environment.
  • Type your commands in a text editor and copy-paste them into SQL Live. In the past, data and tables have been lost. If your commands are saved, you can recreate your tables and data.
  • Once you type your SQL command, you must click on the RUN button on the top right. The return will not execute your command.

You can stack your commands however, you cannot run multiple commands at once, you must highlight the command you wa