# Toad 12.5 - Code Assist not using table alias!

**URL:** <https://forums.toadworld.com/t/toad-12-5-code-assist-not-using-table-alias/30143>\
**Category:** Toad for Oracle & DevOps Toolkit\
**Created:** [June 10, 2014, 8:29am UTC](https://forums.toadworld.com/t/toad-12-5-code-assist-not-using-table-alias/30143 "2014-06-10T08:29:33Z")\
**Posts on this page:** 13\
**Page:** 1

<div class="post-metadata">

**Author:** ![cstaber](https://avatars.discourse-cdn.com/v4/letter/c/85e7bf/32.png) [@cstaber](https://forums.toadworld.com/u/cstaber)\
**Post date:** [June 10, 2014, 8:29am UTC](https://forums.toadworld.com/t/toad-12-5-code-assist-not-using-table-alias/30143/1 "2014-06-10T08:29:33Z")

</div>

If I have something like this:

SELECT  
i.  
FROM  
dss\_icsmgt\_stage.e\_cp\_ics\_initiative i

When I get to the “i.” and select a column from the menu, rather than it displaying “i.column\_name”, it changes to “e\_cp\_ics\_initiative.column\_name”. I upgraded from 12.1 and it was working with the aliases before. I tried going through the options menu, but couldn’t seem to find anything.

Any help would be greatly appreciated!

Thanks!

-Chris

---

<div class="post-metadata">

**Author:** ![mstaszew](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/mstaszew/32/23_2.png) [@mstaszew](https://forums.toadworld.com/u/mstaszew)\
**Post date:** [June 10, 2014, 8:39am UTC](https://forums.toadworld.com/t/toad-12-5-code-assist-not-using-table-alias/30143/2 "2014-06-10T08:39:48Z")

</div>

I don't think it could be option related, but to rule that out please email me your Toad.ini file offline to michael.staszewski[quest.com](http://quest.com)

I tried with the following SQL and it retained the alias. select i. from scott.emp i

Michael

On 06/10/2014 11:30 AM, cstaber wrote:

> **Toad 12.5 - Code Assist not using table alias!**

> Thread created by cstaber  
> If I have something like this:

> SELECT  
> i.  
> FROM  
> dss\_icsmgt\_stage.e\_cp\_ics\_initiative i

> When I get to the "i." and select a column from the menu, rather than it displaying "i.column\_name", it changes to "e\_cp\_ics\_initiative.column\_name". I upgraded from 12.1 and it was working with the aliases before. I tried going through the options menu, but couldn't seem to find anything.

> Any help would be greatly appreciated!

> Thanks!

> -Chris

> 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.

> ![](https://global.discourse-cdn.com/quest/original/3X/5/0/50b30fd5f87c85fe5cba2635cb83316ca71250d7.gif)

---

<div class="post-metadata">

**Author:** ![cstaber](https://avatars.discourse-cdn.com/v4/letter/c/85e7bf/32.png) [@cstaber](https://forums.toadworld.com/u/cstaber)\
**Post date:** [June 10, 2014, 8:43am UTC](https://forums.toadworld.com/t/toad-12-5-code-assist-not-using-table-alias/30143/3 "2014-06-10T08:43:53Z")

</div>

Actually, I just closed everything and restarted my computer and now it’s working and using the alias. Weird. I think I’m good now - I’ll keep an eye on it.

Thanks!

-Chris

\*\*\* Nevermind, didn’t really fix it 🙂

---

<div class="post-metadata">

**Author:** ![cstaber](https://avatars.discourse-cdn.com/v4/letter/c/85e7bf/32.png) [@cstaber](https://forums.toadworld.com/u/cstaber)\
**Post date:** [June 10, 2014, 8:48am UTC](https://forums.toadworld.com/t/toad-12-5-code-assist-not-using-table-alias/30143/4 "2014-06-10T08:48:14Z")

</div>

Actually, I just realized it was only working because I didn’t use a schema name in the FROM. When you use a schema.table\_name - it doesn’t pick up the alias. When you just list the table name by itself without the schema prefix, it then picks up the alias. This holds true every time so far. So I guess it’s not quite fixed 😕

---

<div class="post-metadata">

**Author:** ![mstaszew](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/mstaszew/32/23_2.png) [@mstaszew](https://forums.toadworld.com/u/mstaszew)\
**Post date:** [June 10, 2014, 8:49am UTC](https://forums.toadworld.com/t/toad-12-5-code-assist-not-using-table-alias/30143/5 "2014-06-10T08:49:49Z")

</div>

In my sample SQL the schema name was included.

On 06/10/2014 11:48 AM, cstaber wrote:

> **[RE: Toad 12.5 - Code Assist not using table alias!](http://www.toadworld.com/products/toad-for-oracle/f/10/p/22118/47093.aspx#47093)**

> Reply by cstaber  
> Actually, I just realized it was only working because I didn't use a schema name in the FROM. When you use a schema.table\_name - it doesn't pick up the alias. When you just list the table name by itself without the schema prefix, it then picks up the alias.  
> This holds true every time so far. So I guess it's not quite fixed 😕

> To reply, please reply-all to this email.
> 
> [Stop receiving emails](http://www.toadworld.com/products/toad-for-oracle/f/10/t/22118.aspx?subscribe=false) on this subject.
> 
> Or [  
> Unsubscribe from Toad for Oracle - General](http://www.toadworld.com/products/toad-for-oracle/f/10.aspx?subscribe=false) notifications altogether.
> 
> Toad for Oracle - Discussion Forum

> [Flag](http://www.toadworld.com/products/toad-for-oracle/f/10/p/22118/47093.aspx?AbuseContentId=b3d03f0d-4920-4c97-a6be-85151bc06ed0&AbuseContentTypeId=f586769b-0822-468a-b7f3-a94d480ed9b0&AbuseFlag=true)  
> this post as spam/abuse.

> ![](https://global.discourse-cdn.com/quest/original/3X/5/0/50b30fd5f87c85fe5cba2635cb83316ca71250d7.gif)

---

<div class="post-metadata">

**Author:** ![mstaszew](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/mstaszew/32/23_2.png) [@mstaszew](https://forums.toadworld.com/u/mstaszew)\
**Post date:** [June 10, 2014, 8:52am UTC](https://forums.toadworld.com/t/toad-12-5-code-assist-not-using-table-alias/30143/6 "2014-06-10T08:52:48Z")

</div>

Ignore my last comment. You're using the schema name you are logged in as I assume. I see it under this condition as well.

On 06/10/2014 11:50 AM, Michael Staszewski wrote:

> **[Re: Toad 12.5 - Code Assist not using table alias!](http://www.toadworld.com/products/toad-for-oracle/f/10/p/22118/47094.aspx#47094)**

> Reply by Michael Staszewski  
> In my sample SQL the schema name was included.
> 
> On 06/10/2014 11:48 AM, cstaber wrote:

> > **[RE: Toad 12.5 - Code Assist not using table alias!](http://www.toadworld.com/products/toad-for-oracle/f/10/p/22118/47093.aspx#47093)**

> > Reply by cstaber  
> > Actually, I just realized it was only working because I didn't use a schema name in the FROM. When you use a schema.table\_name - it doesn't pick up the alias. When you just list the table name by itself without the schema prefix, it then picks up the alias.  
> > This holds true every time so far. So I guess it's not quite fixed 😕

> > To reply, please reply-all to this email.
> > 
> > [Stop receiving emails](http://www.toadworld.com/products/toad-for-oracle/f/10/t/22118.aspx?subscribe=false) on this subject.
> > 
> > Or [  
> > Unsubscribe from Toad for Oracle - General](http://www.toadworld.com/products/toad-for-oracle/f/10.aspx?subscribe=false) notifications altogether.
> > 
> > Toad for Oracle - Discussion Forum

> > [Flag](http://www.toadworld.com/products/toad-for-oracle/f/10/p/22118/47093.aspx?AbuseContentId=b3d03f0d-4920-4c97-a6be-85151bc06ed0&AbuseContentTypeId=f586769b-0822-468a-b7f3-a94d480ed9b0&AbuseFlag=true)  
> > this post as spam/abuse.

> > ![](https://global.discourse-cdn.com/quest/original/3X/5/0/50b30fd5f87c85fe5cba2635cb83316ca71250d7.gif)

> To reply, please reply-all to this email.
> 
> [Stop receiving emails](http://www.toadworld.com/products/toad-for-oracle/f/10/t/22118.aspx?subscribe=false) on this subject.
> 
> Or [  
> Unsubscribe from Toad for Oracle - General](http://www.toadworld.com/products/toad-for-oracle/f/10.aspx?subscribe=false) notifications altogether.
> 
> Toad for Oracle - Discussion Forum

> [Flag](http://www.toadworld.com/products/toad-for-oracle/f/10/p/22118/47094.aspx?AbuseContentId=30eebcc4-a825-4b39-8c60-192f6b466f98&AbuseContentTypeId=f586769b-0822-468a-b7f3-a94d480ed9b0&AbuseFlag=true)  
> this post as spam/abuse.

> ![](https://global.discourse-cdn.com/quest/original/3X/5/0/50b30fd5f87c85fe5cba2635cb83316ca71250d7.gif)

---

<div class="post-metadata">

**Author:** ![cstaber](https://avatars.discourse-cdn.com/v4/letter/c/85e7bf/32.png) [@cstaber](https://forums.toadworld.com/u/cstaber)\
**Post date:** [June 10, 2014, 8:54am UTC](https://forums.toadworld.com/t/toad-12-5-code-assist-not-using-table-alias/30143/7 "2014-06-10T08:54:04Z")

</div>

Oh yes, that is true. I was using the schema name I was connected as.

---

<div class="post-metadata">

**Author:** ![phartzsch](https://avatars.discourse-cdn.com/v4/letter/p/c89c15/32.png) [@phartzsch](https://forums.toadworld.com/u/phartzsch)\
**Post date:** [June 10, 2014, 11:21pm UTC](https://forums.toadworld.com/t/toad-12-5-code-assist-not-using-table-alias/30143/8 "2014-06-10T23:21:29Z")

</div>

Hi,

I have the same problem. My logon schema is another then my default schema. Why doesn’t work FROM SCHEMA.T\_TABLE\_NAME anymore?

---

<div class="post-metadata">

**Author:** ![mstaszew](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/mstaszew/32/23_2.png) [@mstaszew](https://forums.toadworld.com/u/mstaszew)\
**Post date:** [June 11, 2014, 6:56am UTC](https://forums.toadworld.com/t/toad-12-5-code-assist-not-using-table-alias/30143/9 "2014-06-11T06:56:08Z")

</div>

I think this is the same issue as reported by cstaber, but to be sure is this your scenario?

1. Logged in as schema A.

2. Default schema dropdown set to schema B.

3. Query looks something like "select i. from B.tablename" and "i" is replaced by "tablename" when you select an item from the popup.

Is that your setup?

Thanks,

Michael

On 06/11/2014 02:21 AM, phartzsch wrote:

> **[RE: Toad 12.5 - Code Assist not using table alias!](http://www.toadworld.com/products/toad-for-oracle/f/10/p/22118/47104.aspx#47104)**

> Reply by phartzsch  
> Hi,

> I have the same problem. My logon schema is another then my default schema. Why doesn't work FROM SCHEMA.T\_TABLE\_NAME anymore?

> To reply, please reply-all to this email.
> 
> [Stop receiving emails](http://www.toadworld.com/products/toad-for-oracle/f/10/t/22118.aspx?subscribe=false) on this subject.
> 
> Or [  
> Unsubscribe from Toad for Oracle - General](http://www.toadworld.com/products/toad-for-oracle/f/10.aspx?subscribe=false) notifications altogether.
> 
> Toad for Oracle - Discussion Forum

> [Flag](http://www.toadworld.com/products/toad-for-oracle/f/10/p/22118/47104.aspx?AbuseContentId=b9a0f804-0708-4279-890b-398c4e38090b&AbuseContentTypeId=f586769b-0822-468a-b7f3-a94d480ed9b0&AbuseFlag=true)  
> this post as spam/abuse.

> ![](https://global.discourse-cdn.com/quest/original/3X/5/0/50b30fd5f87c85fe5cba2635cb83316ca71250d7.gif)

---

<div class="post-metadata">

**Author:** ![mstaszew](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/mstaszew/32/23_2.png) [@mstaszew](https://forums.toadworld.com/u/mstaszew)\
**Post date:** [June 11, 2014, 7:25am UTC](https://forums.toadworld.com/t/toad-12-5-code-assist-not-using-table-alias/30143/10 "2014-06-11T07:25:09Z")

</div>

This is fixed for first 12.6 beta.

Thanks,

Michael

On 06/10/2014 11:30 AM, cstaber wrote:

> **[Toad 12.5 - Code Assist not using table alias!](http://www.toadworld.com/products/toad-for-oracle/f/10/t/22118.aspx)**

> Thread created by cstaber  
> If I have something like this:

> SELECT
> 
> ```
> i.
> 
> ```
> 
> FROM
> 
> ```
> dss_icsmgt_stage.e_cp_ics_initiative i
> 
> ```

> When I get to the "i." and select a column from the menu, rather than it displaying "i.column\_name", it changes to "e\_cp\_ics\_initiative.column\_name". I upgraded from 12.1 and it was working with the aliases before. I tried going through the options menu,  
> but couldn't seem to find anything.

> Any help would be greatly appreciated!

> Thanks!

> -Chris

> To reply, please reply-all to this email.
> 
> [Stop receiving emails](http://www.toadworld.com/products/toad-for-oracle/f/10/t/22118.aspx?subscribe=false) on this subject.
> 
> Or [  
> Unsubscribe from Toad for Oracle - General](http://www.toadworld.com/products/toad-for-oracle/f/10.aspx?subscribe=false) notifications altogether.
> 
> Toad for Oracle - Discussion Forum

> [Flag](http://www.toadworld.com/products/toad-for-oracle/f/10/t/22118.aspx?AbuseContentId=3a3f72cf-6935-43f6-bfa7-56e60dd0029f&AbuseContentTypeId=46448885-d0e6-4133-bbfb-f0cd7b0fd6f7&AbuseFlag=true)  
> this post as spam/abuse.

> ![](https://global.discourse-cdn.com/quest/original/3X/5/0/50b30fd5f87c85fe5cba2635cb83316ca71250d7.gif)

---

<div class="post-metadata">

**Author:** ![danny.torres](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/danny.torres/32/183_2.png) [@danny.torres](https://forums.toadworld.com/u/danny.torres)\
**Post date:** [June 13, 2014, 6:49am UTC](https://forums.toadworld.com/t/toad-12-5-code-assist-not-using-table-alias/30143/11 "2014-06-13T06:49:30Z")

</div>

Hi Michael,

I got a SR with the same issue.

I see it will be fixed in 12.6.

Could I get a CR defect ID to give to my user and to create a solution?

Thank you.

---

<div class="post-metadata">

**Author:** ![mark.s.pedrick](https://avatars.discourse-cdn.com/v4/letter/m/8c91f0/32.png) [@mark.s.pedrick](https://forums.toadworld.com/u/mark.s.pedrick)\
**Post date:** [April 21, 2015, 6:15pm UTC](https://forums.toadworld.com/t/toad-12-5-code-assist-not-using-table-alias/30143/12 "2015-04-21T18:15:47Z")

</div>

I am running Toad 12.6.0.53 and it is definetly NOT fixed. Code assist bubble worked sporadically, then only when logged in with Windows Admin rights and now not at all.

I’ve used the Utilities and created new user files to no avail. I’ve checked and unchecked Public synonyms as well as checked and unchecked Synonyms - all to no avail.

Is there anyone who can assist getting Code Assist working in 12.6.0.53?

Thank you

Update - OK, I may be on to something. I got Code assist to work using table aliases on 12.6.0.53 but only if a table is listed once and only once in the query with a single alias. If you need to join the same table more than once in a query using different aliases, it stops working for all aliases within the query.

---

<div class="post-metadata">

**Author:** ![stalsy](https://avatars.discourse-cdn.com/v4/letter/s/bbce88/32.png) [@stalsy](https://forums.toadworld.com/u/stalsy)\
**Post date:** [May 31, 2015, 6:16pm UTC](https://forums.toadworld.com/t/toad-12-5-code-assist-not-using-table-alias/30143/13 "2015-05-31T18:16:05Z")

</div>

I am also running Toad 12.6.0.53 and it is definetly NOT fixed.

I’m running Toad on a WIN 7 VM machine. I seems to work for a while after I reboot the VM, however soon after it starts to work only for some tables and finally it only works when I use it for a fully qualified table (Press Ctrl + T after the period of Schema.TableName. ).

I tried restarting Toad only (without rebooting) but this does not solve the issue.
