The pick-list dropdown is not triggering in certain situations. Using the CTRL-T key combo doesn’t help.
Example 1
Triggers here:
select * from user_objects uo where uo.
Doesn’t: trigger here when select is part of create table statement:
create table test as select * from user_objects uo where uo.
Example 2
Triggers here when referencing alias for the first table in join:
select * from user_objects uo join user_tables ut on ut.
Doesn’t trigger here when referencing alias for second table in join:
select * from user_objects uo join user_tables ut on ut.tablename = uo.
Example 3
Triggers here using alias for first table:
select * from user_objects uo, user_table ut where uo.
Doesn’t trigger here when using the alias for the second table:
select * from user_objects uo, user_table ut where ut.
I have 1 and 2 fixed for next 12.6 beta. Item 3 looks like a typo. You have USER_TABLE instead of USER_TABLES.
Thanks,
Michael
On 07/02/2014 03:41 PM, raymond.leung wrote:
12.5.0.99 Pick-list dropdown not triggering
Thread created by raymond.leung
The pick-list dropdown is not triggering in certain situations. Using the CTRL-T key combo doesn't help.
Example 1
Triggers here:
select * from user_objects uo where uo.
Doesn't: trigger here when select is part of create table statement:
create table test as select * from user_objects uo where uo.
Example 2
Triggers here when referencing alias for the first table in join:
select * from user_objects uo join user_tables ut on ut.
Doesn't trigger here when referencing alias for second table in join:
select * from user_objects uo join user_tables ut on ut.tablename = uo.
Example 3
Triggers here using alias for first table:
select * from user_objects uo, user_table ut where uo.
Doesn't trigger here when using the alias for the second table:
select * from user_objects uo, user_table ut where ut.
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.
Yes, Example 3 was a typo. Sorry.
Note that Example 2 is also an issue with CREATE MATERIALIZED_VIEW statement as well.
When will 12.6 be available?
Confirmed it is fixed in 12.5.1