Personal oracle lite (POL) - Explain how to replicate data using Oracle Lite
posted by Babu Kunwar
Explain how to replicate data using Oracle Lite
Oracle Database Lite has built in replication functionality. At the database
level Oracle Lite supports the CREATE SNAPSHOT command. This creates a special
table that automatically tracks changes to rows on that table.
This can be seen through the SQL engine using the OL__ROW_STATUS pseudo column.
Value 16 means an inserted row, 32 means an update row and 80 means a deleted
row. By adding a + to the table name the SQL engine lists only those rows that
have a non zero row status. Surrounding this functionality is a small client
side component, mSync and a large server side component consisting of the
Mobile Server and the MGP.
More links
What is a PL/SQL Record data type?
Define and declare Records
Different Types of Records - Table-based, Cursor-based, Programmer-defined
Benefits of using Records
Guidelines for using Records............
|
