Pick list gives me columns from wrong table

Toad for Oracle
1

Hi,

I have just updated to Toad for Oracle 12.6.0.53 and have discovered a new "feature" when multiple tables in the same editor (in different statements) are given the same alias....

Previously, the pick list returned the columns from the table within the relevant statement. Now it returns the columns from the top table with the specific alias even if the cursor is in a completely different statement.

I have included a screen print below. As can be seen does the pick list show the columns from "all_tables" and not "all_tab_columns" as I would like it to.

Can this be changed anywhere. It is really annoying as I have always used a,b,c,d,... as alias.

In advance, thanks

Carl

8712.Toad.png
8712.Toad.png1280×1024 143 KB

2

Terminate your first statement with a semicolon and it will show correctly.

On Jun 22, 2015, at 7:52 AM, Carl_L bounce-Carl_L@toadworld.com wrote:

Pick list gives me columns from wrong table

Thread created by Carl_L
Hi,

I have just updated to Toad for Oracle 12.6.0.53 and have discovered a new "feature" when multiple tables in the same editor (in different statements) are given the same alias....

Previously, the pick list returned the columns from the table within the relevant statement. Now it returns the columns from the top table with the specific alias even if the cursor is in a completely different statement.

I have included a screen print below. As can be seen does the pick list show the columns from "all_tables" and not "all_tab_columns" as I would like it to.

Can this be changed anywhere. It is really annoying as I have always used a,b,c,d,... as alias.

In advance, thanks

Carl

To reply, please reply-all to this email.

Stop receiving emails on this subject.

Or
Unsubscribe from Toad for Oracle - General notifications altogether.

Toad for Oracle - Discussion Forum

Flag
this post as spam/abuse.

3

Hi,

Thanks for the answer. Is there a way to chage this so that it works like in previous versions (that is, whithout having to use the semicolon)?

A small thing of course, but it would be very nice since I am very used to this after 8 years of Toad usage…

Br,

Carl

4

This problem with the semicolon is still relevant, will it be fixed in new versions of Toad?

5

I'm not saying it will never be fixed, but it is low priority.

The editor can do a better job of parsing your sql if you tell it where your statements end. Blank lines in SQL are acceptable. But if you have no semicolons, we have to start guessing where your sql begins and ends. It's really best if you have semicolons.