I thought I'd share a resource that I've found useful:


There is a website called db<>fiddle (https://dbfiddle.uk/) that has free online database instances that can be used for testing purposes.

For example, my Maximo database is Oracle, but I wanted to test something out in SQL Server. I don't have a local SQL Server database that I can use, so I used db<>fiddle instead:  https://dbfiddle.uk/?rdbms=sqlserver_2019&fiddle=078efa6d52d9a3f044329ea528511535




Notes:

• https://dbfiddle.uk/ is not to be confused with https://www.db-fiddle.com/ or http://sqlfiddle.com/. The first link is used heavily by the guys on https://dba.stackexchange.com/ . I don't have any experience with the second or third link. Although it seems like DBAs prefer to use the first link.
• The sessions are permanent, public, and shareable. Just copy the URL to share the work that you did. Example: https://dbfiddle.uk/?rdbms=sqlserver_2019&fiddle=078efa6d52d9a3f044329ea528511535
• Each line is an individual SQL statement. We can't put multiple statements in a single line. But, I think there are tricks for bulk-inserting data like putting a bunch of test data in a single WITH clause (Toad can generate the WITH clause automatically). There are probably other tricks too.
• Sometimes, a SQL statement needs to end with a / . Similar to SQL Plus (Oracle). More info here: DB<>Fiddle: Custom type and function (ORA-24344)

Do you have any other online database testing websites that you use?
#AssetandFacilitiesManagement
#Maximo

Oracle Live SQL is another option: https://livesql.oracle.com/

I'm not sure if it's shareable or not.
#Maximo
#AssetandFacilitiesManagement

For what it's worth, it looks like Oracle 21c was recently added to db<>fiddle:


Original Message:
Sent: Thu November 25, 2021 09:34 AM
From: User1971
Subject: Free online database instances (Oracle, SQL Server, DB2, more)

Oracle Live SQL is another option: https://livesql.oracle.com/

I'm not sure if it's shareable or not.
#AssetandFacilitiesManagement
#Maximo

This isn't related, but I'll post it here anyway, just in case it's of interest to someone:

Return a resultset as JSON text-using "pretty" formatting (Oracle21c)

SELECT json_object(* PRETTY)
from dual;

Outputs JSON text:

{
  "DUMMY" : "X"
}

#Maximo
#AssetandFacilitiesManagement