cmatt
October 3, 2014, 8:02am
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
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.
cmatt
October 3, 2014, 8:29am
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]
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.
cmatt
October 3, 2014, 9:08am
5
Correct. It was there. Additionally I selected Synonyms and it started working.
You are a champ.
Thanks and you’re welcome.