3

Is there some trick to getting SQL Code Assist working in Eclipse? I have opened an SQL scrapbook page, assigned it a type, connection name and database.. and tried to type some SQL.

If I enter a schema name.. 

select * from public.

It shows me a list of tables.. so I can select one and get:

select * from public.batch_job_instance

but that's it. Once I start on the WHERE clause there is no help. It doesn't matter whether I put public or public.batch_job_instance (or just hurl obscenities at my monitor for five minutes - I tried that a few times) there is no further "assistance".

How exactly do I get this code assist to assist me?

OMG Ponies
  • 325,700
  • 82
  • 523
  • 502
Robert Mark Bram
  • 8,104
  • 8
  • 52
  • 73
  • 2
    possible duplicate of [Eclipse sql code completion](http://stackoverflow.com/questions/9957656/eclipse-sql-code-completion) –  Apr 01 '12 at 19:08
  • As an update, I no longer use the default database tooling in Eclipse. Instead, I now use DBeaver for Eclipse - it is magnificent and has much better tooling for code assisting SQL. – Robert Mark Bram Jul 18 '14 at 14:53

0 Answers0