Maximo

 View Only
  • 1.  Free online database instances (Oracle, SQL Server, DB2, more)

    Posted Thu November 25, 2021 09:30 AM
    Edited by User1971 Mon January 03, 2022 01:42 PM
    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:


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


  • 2.  RE: Free online database instances (Oracle, SQL Server, DB2, more)

    Posted Thu November 25, 2021 09:35 AM
    Edited by User1971 Thu November 25, 2021 10:08 AM
    Oracle Live SQL is another option: https://livesql.oracle.com/

    I'm not sure if it's shareable or not.


  • 3.  RE: Free online database instances (Oracle, SQL Server, DB2, more)

    Posted Tue December 07, 2021 10:16 PM
    For what it's worth, it looks like Oracle 21c was recently added to db<>fiddle:




  • 4.  RE: Free online database instances (Oracle, SQL Server, DB2, more)

    Posted Sun January 02, 2022 12:54 PM
    Edited by User1971 Sun January 02, 2022 12:54 PM

    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"
    }