Pop-up window with list of columns

Toad for Oracle
1

TOAD Version - 11.0.0.116

My TOAD is not showing any pop-up window with list of columns while writing queries.

Ex: When I write something like below…

select * from fnd_user a where a.

The moment I enter “a.” it supposed to give list of all columns in that FND_USER table, but it is not.

Is there any property I need to set this up?

Thanks

2

In Options|Editor|Code Assist make sure you have "Enable Code Insight pick lists" checked. Check the value in the "Delay pop-ups" edit box. Also make sure that you have tables checked in the "Toad Insight Objects" box.

On 10/03/2014 11:03 AM, cmatt wrote:

Pop-up window with list of columns

Thread created by cmatt
TOAD Version - 11.0.0.116

My TOAD is not showing any pop-up window with list of columns while writing queries.

Ex: When I write something like below..

select * from fnd_user a where a.

The moment I enter "a." it supposed to give list of all columns in that FND_USER table, but it is not.

Is there any property I need to set this up?

Thanks

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

– Also make sure that you have tables checked in the “Toad Insight Objects” box.

I don’t see this in my TOAD (View/TOAD Options/Editor/Code Assist)

As you can see, it is giving me the pop-up, but not the column names of table FND_USER, but another table name "A.

Please help.

[View:~/cfs-file.ashx/_key/communityserver-discussions-components-files/10/Toad-Issue_2E00.docx:550:0]

4

I'm guessing that FND_USER is a synonym. Make sure you have have synonyms checked for inclusion in that Toad Insight Objects box.

I don't see this in my TOAD (View/TOAD Options/Editor/Code Assist)

It's there, look again. I'm also using Toad 11.0.0.116.

On 10/03/2014 11:30 AM, cmatt wrote:

RE: Pop-up window with list of columns

Reply by cmatt
-- Also make sure that you have tables checked in the "Toad Insight Objects" box.

I don't see this in my TOAD (View/TOAD Options/Editor/Code Assist)

As you can see, it is giving me the pop-up, but not the column names of table FND_USER, but another table name "A.

Please help.

http://www.toadworld.com/cfs-file.ashx/_key/communityserver-discussions-components-files/10/Toad-Issue_2E00.docx

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.

5

Correct. It was there. Additionally I selected Synonyms and it started working.

You are a champ. :slight_smile:

6

Thanks and you’re welcome.

champion1.png