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.

Compared to Oracle

SQLite is similar to Oracle's Berkeley DB database. However, unlike Berkley DB, SQLite also supports the SQL language.

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.

External links

• SQLite Home Page