publish by value: In this type the changes in the source table are reflected in the p_table and the data s TAKEN from there. Its used when high speed is required. It does not SUPPORT data types like oracle long.

publish by reference: In this type the data is DIRECTLY taken from the source table where only the primary key will COME from p_table. It allows data types like oracle long. Loss of changes in the source table can be lost because of the waiting time. (This can be avoided USING alerter).

publish by value: In this type the changes in the source table are reflected in the p_table and the data s taken from there. Its used when high speed is required. It does not support data types like oracle long.

publish by reference: In this type the data is directly taken from the source table where only the primary key will come from p_table. It allows data types like oracle long. Loss of changes in the source table can be lost because of the waiting time. (This can be avoided using alerter).