# Editor - insight popup

**URL:** <https://forums.toadworld.com/t/editor-insight-popup/27634>\
**Category:** Toad for Oracle - Beta\
**Created:** [November 14, 2013, 12:49pm UTC](https://forums.toadworld.com/t/editor-insight-popup/27634 "2013-11-14T12:49:13Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![eklinger](https://avatars.discourse-cdn.com/v4/letter/e/bbe5ce/32.png) [@eklinger](https://forums.toadworld.com/u/eklinger)\
**Post date:** [November 14, 2013, 12:49pm UTC](https://forums.toadworld.com/t/editor-insight-popup/27634/1 "2013-11-14T12:49:13Z")

</div>

Beta .5

I’ve been out of the loop on the beta’s so far for 12.5 so I updated it today to get back into it.

When doing a SQL with an alias after typing the alias"." and picking a column why is the table name being returned with the column name. I get alias.tablename.columnname when I press enter??

Thanks!

Ed

---

<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:** [November 14, 2013, 12:57pm UTC](https://forums.toadworld.com/t/editor-insight-popup/27634/2 "2013-11-14T12:57:16Z")

</div>

Some changes were made here recently so I may have introduced a bug, but I cannot reproduce it. Using this SQL and selecting a column I get only e.. Do you have a sample? I'm in 12.5.0.5.

select e. from emp e;

On 11/14/2013 03:49 PM, ed.klinger wrote:

> **[Editor - insight popup](http://www.toadworld.com/products/toad-for-oracle/toad_for_oracle_beta_program/f/86/t/20770.aspx)**

> Thread created by ed.klinger  
> Beta .5

> 

> I've been out of the loop on the beta's so far for 12.5 so I updated it today to get back into it.

> 

> When doing a SQL with an alias after typing the alias"." and picking a column why is the table name being returned with the column name. I get alias.tablename.columnname when I press enter??

> 

> Thanks!

> 

> Ed

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

> [Flag](http://www.toadworld.com/products/toad-for-oracle/toad_for_oracle_beta_program/f/86/t/20770.aspx?AbuseContentId=4b1e3ecb-e6f2-45a5-8f43-c17d0aa7957e&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:** ![eklinger](https://avatars.discourse-cdn.com/v4/letter/e/bbe5ce/32.png) [@eklinger](https://forums.toadworld.com/u/eklinger)\
**Post date:** [November 14, 2013, 1:28pm UTC](https://forums.toadworld.com/t/editor-insight-popup/27634/3 "2013-11-14T13:28:16Z")

</div>

Michael,

After doing a little more testing on this it seem to show up when I use the schema name in the FROM part

select \*

from scott.emp e

where e. ...

Ed

On Nov 14, 2013, at 3:57 PM, Michael Staszewski [bounce-mstaszew@toadworld.com](mailto:bounce-mstaszew@toadworld.com) wrote:

> **[Re: Editor - insight popup](http://www.toadworld.com/products/toad-for-oracle/toad_for_oracle_beta_program/f/86/p/20770/42557.aspx#42557)**

> Reply by Michael Staszewski  
> Some changes were made here recently so I may have introduced a bug, but I cannot reproduce it. Using this SQL and selecting a column I get only e.. Do you have a sample? I'm in 12.5.0.5.
> 
> select e. from emp e;
> 
> On 11/14/2013 03:49 PM, ed.klinger wrote:

> > **[Editor - insight popup](http://www.toadworld.com/products/toad-for-oracle/toad_for_oracle_beta_program/f/86/t/20770.aspx)**

> > Thread created by ed.klinger  
> > Beta .5

> >

> > I've been out of the loop on the beta's so far for 12.5 so I updated it today to get back into it.

> >

> > When doing a SQL with an alias after typing the alias"." and picking a column why is the table name being returned with the column name. I get alias.tablename.columnname when I press enter??

> >

> > Thanks!

> >

> > Ed

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

> > [Flag](http://www.toadworld.com/products/toad-for-oracle/toad_for_oracle_beta_program/f/86/t/20770.aspx?AbuseContentId=4b1e3ecb-e6f2-45a5-8f43-c17d0aa7957e&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)

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

> [Flag](http://www.toadworld.com/products/toad-for-oracle/toad_for_oracle_beta_program/f/86/p/20770/42557.aspx?AbuseContentId=8dff5696-f871-4536-a352-8be1f845d77f&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:** ![nathan.e.schroeder](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/nathan.e.schroeder/32/192_2.png) [@nathan.e.schroeder](https://forums.toadworld.com/u/nathan.e.schroeder)\
**Post date:** [November 14, 2013, 1:44pm UTC](https://forums.toadworld.com/t/editor-insight-popup/27634/4 "2013-11-14T13:44:17Z")

</div>

Same here. Good detective work, Ed.

Nate Schroeder

US Row Crops IT Data Management Team

Monsanto Company

800 N. Lindbergh Blvd. G3WB - Saint Louis, MO - 63167

314-694-2592

**From:** ed.klinger [[mailto:bounce-eklinger@toadworld.com](mailto:bounce-eklinger@toadworld.com)]

**Sent:** Thursday, November 14, 2013 3:28 PM

**To:** [toadoraclebeta@toadworld.com](mailto:toadoraclebeta@toadworld.com)

**Subject:** Re: [Toad for Oracle - Beta Discussion Forum] Editor - insight popup

**[Re: Editor - insight popup](http://www.toadworld.com/products/toad-for-oracle/toad_for_oracle_beta_program/f/86/p/20770/42558.aspx#42558)**

Reply by ed.klinger

Michael,

After doing a little more testing on this it seem to show up when I use the schema name in the FROM part

select \*

from scott.emp e

where e. ...

Ed

On Nov 14, 2013, at 3:57 PM, Michael Staszewski [bounce-mstaszew@toadworld.com](mailto:bounce-mstaszew@toadworld.com) wrote:

> 

> **[Re: Editor - insight popup](http://www.toadworld.com/products/toad-for-oracle/toad_for_oracle_beta_program/f/86/p/20770/42557.aspx#42557)**

> Reply by Michael Staszewski

> Some changes were made here recently so I may have introduced a bug, but I cannot reproduce it. Using this SQL and selecting a column I get only e..  
> Do you have a sample? I'm in 12.5.0.5.
> 
> select e. from emp e;

> On 11/14/2013 03:49 PM, ed.klinger wrote:

> > **[Editor - insight popup](http://www.toadworld.com/products/toad-for-oracle/toad_for_oracle_beta_program/f/86/t/20770.aspx)**

> > Thread created by ed.klinger

> > Beta .5

> >

> > I've been out of the loop on the beta's so far for 12.5 so I updated it today to get back into it.

> >

> > When doing a SQL with an alias after typing the alias"." and picking a column why is the table name being returned with the column name. I get alias.tablename.columnname  
> > when I press enter??

> >

> > Thanks!

> >

> > Ed

This e-mail message may contain privileged and/or confidential information, and is intended to be received only by persons entitled

to receive such information. If you have received this e-mail in error, please notify the sender immediately. Please delete it and

all attachments from any servers, hard drives or any other media. Other use of this e-mail by you is strictly prohibited.

All e-mails and attachments sent and received are subject to monitoring, reading and archival by Monsanto, including its

subsidiaries. The recipient of this e-mail is solely responsible for checking for the presence of "Viruses" or other "Malware".

Monsanto, along with its subsidiaries, accepts no liability for any damage caused by any such code transmitted by or accompanying

this e-mail or any attachment.

The information contained in this email may be subject to the export control laws and regulations of the United States, potentially

including but not limited to the Export Administration Regulations (EAR) and sanctions regulations issued by the U.S. Department of

Treasury, Office of Foreign Asset Controls (OFAC). As a recipient of this information you are obligated to comply with all

applicable U.S. export laws and regulations.

---

<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:** [December 11, 2013, 2:08pm UTC](https://forums.toadworld.com/t/editor-insight-popup/27634/5 "2013-12-11T14:08:38Z")

</div>

Fixed for next beta.

Michael
