Code Assistant - Tables

[Marius Moga]

Hi all,

I am quite new to PL SQL Developer as I am switching from MS SQL.

One question - should the Code Assistant show tables names / schema in a select * from context?

So I start typing "select * from " and then I invoke it and the only thing it says it is "The code assistant can only be activated after a period, comma, left paranthesis, ampersand or at the end of a word ...

I was expecting it will show me the list of tables I could use for my select ... Am I doing something wrong?

Thank you,
Marius

 

[Marco Kalter]

You will first need to enter the first characters (by default 3) of the table name before the Code Assistant is invoked. For example, after typing:

select * from emp|

the Code Assistant will show all database object names starting with "EMP". On the Code Assistant preference page you can increase or decrease the number of characters before the Code Assistant is invoked.