Most of the times, we are in need to validate our query with the test data for validation purpose and proof of concept.
Recently I came across the SQL Fiddle and got hooked to it to validate my query to match the expected results.
SQL Fiddle not only provide list of database including oracle and also a new cloud base tool to validate your query and sharing your schema over various forum