SQLite
From Oracle FAQ
SQLite is an open source software library that implements a self-contained (single file), zero-configuration, transactional SQL database engine. SQLite supports multi-user access, but only a single user can update the database at a time. It is largely an "untyped" system and all data is stored as strings. SQLite is widely used in desktop applications and consumer devices including cellphones, PDAs, and MP3 players.
[edit] Compared to Oracle
SQLite is similar to Oracle's Berkeley DB database. However, unlike Berkley DB, SQLite also supports the SQL language.
[edit] Migration to and from Oracle
Data must be converted to text and then loaded using each database's native loader utility. For example, use SQL*Loader to load the text files into an Oracle database.
The StepSqlite product from Metatranz LLC is a PL/SQL compiler for SQLite. It supports a subset of PL/SQL and can be used for code migration or parallel development between Oracle and SQLite.
