Re: Reference data manitenance tool?

On Wed, 28 Dec 2005 11:55:01 -0500, "Mark C. Stock" <mcstockX_at_Xenquery .com> wrote:

>
>"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
>

 I stand corrected....

Happy 2006

Best Regards

Rob Zijlstra Received on Wed Dec 28 2005 - 12:46:22 CST