Re: sql editor with code completion

tom.a.miller_at_gmail.com wrote:
> Can somebody please recommend a good oracle sql editor with code
> completion that is free? The main feature I am looking for is:
>

Oracle's SQL Developer (previously known as Raptor) does these, more or less.

> (a) an object browser (view sql table schema, functions, and procedures
> visually)

What do you mean by visually? For table schema you can either check columns as list or SQL statements that were used in creating the table (Grants, constraints etc. also). But if you mean a Visio type diagram where tables are boxes and foreign keys are lines between them, check SQuirreL instead. SQuirreL is not specific to Oracle, which might come in handy.

>
> (b) code compeltion so it finishes table names, column names, variable
> names when I am writing my sql scripts.
>

SQL Developer seems to have this, I have not used it.

--
Arto Viitanen, CSC Ltd
Espoo, Finland