Look at the Editor toolbar and you’ll find a dropdown for the Current Schema. Select the current schema you’re interested in and Toad will automatically issue the necessary ALTER SESSION calls behind the scenes as needed. When done in this way Toad knows of your intentions and the pick list (Code Insight) behaves correctly as well as several other Editor features. Setting it in this way is also required for F9 execution, the traditional method of executing single statements and compiling PL/SQL. Script execution (F5) will pick up on it as you have it in your script, but that’s the only Toad feature that will act on it.
We don’t parse the script and act on the ALTER SESSION for Code Insight. Your simple example wouldn’t be too an issue, but a script could call another script which could do the alter session, the new current schema could be specified by substitution variables, etc. There are too many possibilities. Use the toolbar dropdown and you’ll get the expected behavior.
From: raviSD [mailto:bounce-raviSD@toadworld.com]
Sent: Tuesday, February 09, 2016 5:22 PM
Subject: [Toad for Oracle - Discussion Forum] Pick lists for column names when using table aliases
Pick lists for column names when using table aliases
Thread created by raviSD
New user and just migrated from plsql developer. My question is below :
How do I get pick lists to populate column names when I am using aliases to the tables. Importantly, I do not want to use schema name when writing every query and so I use alter session set current schema and then start querying. In other words,if I use
ALTER SESSION SET CURRENT_SCHEMA = SCOTT;
select * from emp e
Pick lists is not populating columns to pick from. Anything to help solve this.
To reply, please reply-all to this email.
Stop receiving emails on this subject.
Unsubscribe from Toad for Oracle - General notifications altogether.
Toad for Oracle - Discussion Forum
this post as spam/abuse.