Re: Need feedback regarding TOAD, SQL Developer, EzSQL, Bethnic's

DA Morgan (damorgan_at_psoug.org) wrote:

: 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;

: Will they help you build compressed and function based indexes? How many
: versions after you could do it in SQL*Plus?

: 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.

SQL*PLus can do it all - assuming it doesn't crash (windows XP). I have my favourite versions, but I don't always get to choose. It ought to be the tool you could depend on 100%, but some versions are flaky flaky flaky. 10GR2 is the best recently, I don't recall having any problems with that. Received on Wed Dec 13 2006 - 20:04:52 CET