SQL Server local database file equivalent in Oracle [duplicate]

Question

I'm looking for embedded db with Java API for testing purposes. Also i need pl/sql support because we use oracle in production and migrations are written in pl/sql.

I want to test my DAO objects and i need to create db in memory in process of unit test using migration scripts.

Now we use HSQLDB but it does't support pl/sql.

Can you recommend anything?

Answer 1

According to the wikipedia page about PL/SQL, the databases supporting PL/SQL are Oracle and DB2:

• Embedded DB2
• Embedded Oracle

If these don't suit you, there's nothing else. PL/SQL is a creation of Oracle, so it's not expected to be widely spread.