'Red Gate SQL Prompt' like intellisense for Oracle ?

[iPrank]

If you have used Red Gate SQL Prompt, then you know how great it is.
IMO, It provides great intellisense in Sql Svr Managenent Studio.

The things I liked most are,
full intellisense support for database objects,
list automatic joining conditions if there is a relation or field name match,
automatic generation of alias etc.

Last month I have changed my job. My new company uses Oracle back-end. My company uses Toad and Oracle SQL Developer. Both of them are no match for SQL Prompt.

Is there any other SQL editor that will give me better intellisense ?

[abhijit]

If you have used Red Gate SQL Prompt, then you know how great it is.
IMO, It provides great intellisense in Sql Svr Managenent Studio.

The things I liked most are,
full intellisense support for database objects,
list automatic joining conditions if there is a relation or field name match,
automatic generation of alias etc.

Last month I have changed my job. My new company uses Oracle back-end. My company uses Toad and Oracle SQL Developer. Both of them are no match for SQL Prompt.

Is there any other SQL editor that will give me better intellisense ?

Have you tried Pl/SQL Developer from Allround Automation?

[iPrank]

Thanks ! I'll give it a try.

[iPrank]

Thanks. And welcome to VBForums !

[abhijit]

Last month I have changed my job. My new company uses Oracle back-end. My company uses Toad and Oracle SQL Developer. Both of them are no match for SQL Prompt.

Is there any other SQL editor that will give me better intellisense ?

You can try SQL Complete from Devart - a useful add-in for Microsoft SQL Server Management Studio and Microsoft Visual Studio.
Free and advanced paid editions of the SQL code formatter offer powerful autocompletion and formatting of T-SQL code! It replaces native Microsoft T-SQL Intellisense and makes your SQL coding more intuitive and efficient!

And how is that going to work with an Oracle back-end? Inquiring minds would like to know.