Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Reference data manitenance tool?

Re: Reference data manitenance tool?

From: Mark C. Stock <mcstockX_at_Xenquery>
Date: Wed, 28 Dec 2005 11:55:01 -0500
Message-ID: <5dGdnTado9X4Xi_eRVn-tA@comcast.com>

"Rob Zijlstra" <rj.zijlstra_at_tiscali.nl> wrote in message news:lve5r11e83hu93mku0u1n5lju0vrc90pqs_at_4ax.com...
> On 27 Dec 2005 16:15:52 -0800, "Tautology" <SQLTautology_at_xemaps.com>
> wrote:
>
>>I hope you will forgive me the crosspost, I was not sure where to
>>better post this request!
>>
>>I am in need of a tool, preferably spreadsheet-like, in which others
>>can maintain reference data and from which still others can easily
>>generate Insert statements. Any pointers to such tool would be much
>>appreciated!
>>
>>For example, if I have a table with columns
>>RegionID NUMBER NOT NULL
>>RegionName VARCHAR2(30) NOT NULL
>>MajorCity VARCHAR2(30) NULL
>>
>>I want to be able to give this "tool" to a "territory designer," have
>>him or her enter the data he would need, then get the file/tool back
>>and generate a bunch of insert statements that I can use in SQL*Plus or
>>TOAD to push the data into a number of environments where the table
>>exists. I am not looking for whiz-bang tool, $$$ to spend, etc. I am
>>looking for cheap/free, simple, robust and clear to non-technical
>>users. I have put together an Excel spreadsheet that kind of does it,
>>but I'd rather not reinvent this if it already exists.
>>
>>I apologize if this sounds vague -- I did not want to make the
>>description restrictive so that a good tool might fall through its
>>cracks.
>>
>>Any pointers would be much appreciated!
>>Happy Holidays!
>>T.
>
> Hi,
> It may be stupid to ask, but why don't you just use Forms?
>
> Happy Newyear
> Best Regards
>
> Rob Zijlstra

without knowing OP's exact situation, i can think of a couple of reasons: licensing costs & infrastructure ('cheap/free, simple' was part of the requirements)

of course if the OP has a Forms license and has the infrastructure installed, and users are connected, networked, or can access web-based Forms, then it's a viable solution.

++ mcs

++ mcs Received on Wed Dec 28 2005 - 10:55:01 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US