Multiple selection from dropdown lists

[William Robertson]

In PL/SQL Developer 12, I can select multiple items from lists using control-click, but this doesn't seem to work for some of my colleagues. Is there some setting that could affect this? I've looked but I can't see anything likely, and I'm not sure why there would be a preference setting for it anyway.

 

[Marco Kalter]

Can you provide an example of such a list?

 

[William Robertson]

For example, if I start typing a query like

select s. from user_sequences s

so that Code Assistant pops up a list of columns to expand "s."

I have noticed colleagues painstakingly selecting one item at a time, but when I suggest using control-click to select multiple items, it only lets them pick one.

(This is from my home PL/SQL Dev 14 setup as I can't take screenshots from work, but it works fine for me in both versions.)

 

[Marco Kalter]

This does seem to work just fine in 15.0. Can you provide an example from your colleagues where this does not work? Perhaps I can see a restriction.

 

[William Robertson]

I’m not sure how I would do that, as it would just be the same scenario but they can only pick one item off the list where I can pick multiple items, using the same version of PL/SQL Developer (12, though lucky colleagues in another office have 15 but the same issue) and Windows 10. I was just wondering if there are any factors that might affect it. Or maybe they are just doing it wrong somehow.

 

[Marco Kalter]

It can depend on the position in the statement. For the field list you will get an (all) option and multi-select:

select s.| from all_sequences s

For the where clause will will not get the (all) option and multi-select:

select s.* from all_sequences s
where s.|

Perhaps this can explain it?

 

[William Robertson]

No, they seem to have the issue in the select list. Maybe they are just doing it wrong somehow. I'll see if I can try it myself on their PC, though it's not always possible when you are screen-sharing remotely.