Re: Like OracleXE

From: <herodt_at_gmail.com>
Date: 1 Mar 2006 21:11:42 -0800
Message-ID: <1141276302.416495.137980@i40g2000cwc.googlegroups.com>

We do it via MERGE statements and APEX on the laptop.

Laptop reaches out to the host DB runs the merge statements agains the HOST to the laptop. Actually first thing it does is make sure the local PL/SQL is up to date, then gets the data.

Sends some information from the laptop out to the host DB.

Sales person can then download more client info, they can choose all clients in a city, all clients that have bought so much product etc etc.

The entire filtered "made sales guy friendly" dataset is only about 400meg in oracle for all 20K clients for all time and the lifetime sales history.

Real simple to develop, real simple to maintain/add too. Never breaks. Some of the more intelligent sales guys have developer access to their APEX and can built reports to their hearts content.

Beats the old method of 7 MS Access databases that were created on the server and then pulled onto the laptop via Briefcase. Received on Wed Mar 01 2006 - 23:11:42 CST