Personal oracle lite (POL) - How compatible is Oracle Lite with the standard
oracle server? posted by
Babu Kunwar
How compatible is Oracle Lite with the standard oracle server?
Oracle Lite is a database with a small footprint designed to fit on hand held
devices and laptops. Primary use is for replication of an enterprise database.
On the other the oracle server can be used anywhere either for small scale or
large application.
In case of data storage Oracle Lite has some limitation that is we can store
data up to 4GB but Oracle server has no limits to store data.
PL/SQL function/procedures and most triggers are not supported. Only stored
procedures are Java stored procedures. Such is not the case in Oracle server.
Support most but not all of Oracle’s SQL (SQL92).
The supported platform for the database is limited. Development environment
must include Oracle Database Lite 10g as the encompassing platform. For
developing native applications on the Oracle Database Lite 10g platform, the
following operating system platforms are supported:
-
Microsoft Windows NT/2000/XP
-
Windows Mobile 2003 Second Edition software for Pocket PCs
Supported chipset in Windows Mobile 2003
-
Pocket PC 2003 (ARM, xScale, Emulator)
-
Pocket PC (ARM)
More links
What is a PL/SQL package?
Advantages of PL/SQL Packages
What are the types and layers of Packages? Explain them
PL/SQL Packages features
Guidelines for writing packages.........
|
