Re: Need feedback regarding TOAD, SQL Developer, EzSQL, Bethnic's Golden and others ???
From: DA Morgan <damorgan_at_psoug.org>
Date: Tue, 12 Dec 2006 09:05:34 -0800
Message-ID: <1165943133.918743_at_bubbleator.drizzle.com>
>> George Lewycky wrote:
>>> I'm personally a TOAD user but my company is looking to standardize the
>>> product we use for SQL, PL/SQL and Oracle utilities.
>>>
>>> If anyone has done this in the past I'd appreciate your notes, tips,
>>> ideas or pointers to any websites for this (like a Grid comparision)
>>>
>>> I Google'd and found very little except for a few forums and documents
>>> and just the products mentioned above.
>>>
>>>
>>> Thanks in Advance
>>>
>>> George Lewycky
>>> NY City Transit
>>> George.lewycky_at_nyct.com
>> Oracle's SQL*Developer if they want a pretty GUI. But I'm inclined to
>> agree with Roger.
>>
>> If they can't use SQL*Plus ... they likely shouldn't be inside an Oracle
>> database. ;-)
>> --
>> Daniel A. Morgan
>> University of Washington
>> damorgan_at_x.washington.edu
>> (replace x with u to respond)
>> Puget Sound Oracle Users Group
>> www.psoug.org
Date: Tue, 12 Dec 2006 09:05:34 -0800
Message-ID: <1165943133.918743_at_bubbleator.drizzle.com>
What's in a namespace wrote:
> "DA Morgan" <damorgan_at_psoug.org> schreef in bericht > news:1165880924.224493_at_bubbleator.drizzle.com...
>> George Lewycky wrote:
>>> I'm personally a TOAD user but my company is looking to standardize the
>>> product we use for SQL, PL/SQL and Oracle utilities.
>>>
>>> If anyone has done this in the past I'd appreciate your notes, tips,
>>> ideas or pointers to any websites for this (like a Grid comparision)
>>>
>>> I Google'd and found very little except for a few forums and documents
>>> and just the products mentioned above.
>>>
>>>
>>> Thanks in Advance
>>>
>>> George Lewycky
>>> NY City Transit
>>> George.lewycky_at_nyct.com
>> Oracle's SQL*Developer if they want a pretty GUI. But I'm inclined to
>> agree with Roger.
>>
>> If they can't use SQL*Plus ... they likely shouldn't be inside an Oracle
>> database. ;-)
>> --
>> Daniel A. Morgan
>> University of Washington
>> damorgan_at_x.washington.edu
>> (replace x with u to respond)
>> Puget Sound Oracle Users Group
>> www.psoug.org
> > If you can't ride a bike, don't drive a car?????????????????????????????? > > Shakespeare
[Quoted] The problem with many GUI tools, almost by definition, is that they lag behind what the database can do. Which GUIs will let you build either of the following two tables other than by typing it in just as you'd do with SQL*Plus?
CREATE TABLE rowdep_test (
testcol VARCHAR2(20))
ROWDEPENDENCIES;
CREATE TABLE rowmove_test (
testcol VARCHAR2(20))
ENABLE ROW MOVEMENT;
[Quoted] Will they help you build compressed and function based indexes? How many
versions after you could do it in SQL*Plus?
[Quoted] Given that I haven't used any GUI in almost a decade I may be in need of some re-education but I suspect that things haven't changed that much.
-- Daniel A. Morgan University of Washington damorgan_at_x.washington.edu (replace x with u to respond) Puget Sound Oracle Users Group www.psoug.orgReceived on Tue Dec 12 2006 - 18:05:34 CET