Re: graphical interface for oracle table

TOAD would work nice , but it is not a tool for help desk (that would be called TOHD) . TOAD may give them too many options . But, you could just restrict their privileges in Oracle and cover yourself ok.

Also, a solution being simple depends on what you are use to . Your ideas look good.

Another simple (to me) solution would be a Developer 2000 default layout generated form . Run it in a Browser using Oracle9iAS . This would take me about 5 minutes to setup .

"Mark Perrault" <mperrault_at_ingdirect.com> wrote in message news:ee979b3c.0203251141.13574229_at_posting.google.com...
> I have created a table of employee user_id's (multiple systems) that
> allows us to tie transactions to sales agents for a commission
> program. The table is in our production Oracle database and multiple
> systems use it as a cross-reference source.
>
> Our help desk will be updating this table whenever there are new
> hires, terminations, etc. Right now I am doing that manually. Ughhh.
>
> I'd like to develop a simple interface to allow them to perform the
> updates and inserts (no deletions, we leave de-activate the user_id's
> on and keep the reference on the database for historical analysis).
> In a previous shop, I created a Java servlet that would read, update,
> etc an Oracle database. I don't want to go thru all that trouble
> again. Is there a simple way I can allow these users to update the
> table? I was thinking:
>
> 1. Visual Basic
> 2. Microsoft Access linked table (derivative of the VB idea)
> 3. Java Applet
>
> Any ideas? Need it to be rather simple because of the time I've
> allocated to the development. Very few users (5) doing minimal
> updates (a couple a week).
>
> Mark
Received on Wed Mar 27 2002 - 06:46:09 CET