Toad World® Forums

Pick list gives me columns from wrong table


#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


#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