Suppose there are 2 schemas: userA, userB. Both schemas contain table named tab1.
I write a simple query:
select * from userA.tab1;
When I highlight "userA.tab1" -> right click -> "Open Declaration" either of 3 things happens:
1. Nothing happens
2. userA.tab1 table declaration opens
3. userB.tab1 table declaration opens
This is inconsistent and either of 3 can happen at random. "Popup Describe" doesn't show this problem.
I got the same problem, have you fixed the problem (with some workaround) or still waiting for some useful answer?
another freaky behaviour is (same case userA.TAB1 userB.TAB1 -same table_name in different schemas-) no matter whether if I specify the owner or not... I got always information only for one schema (usually the first in alphabetic order).
Edited by: user13781479 on 25-set-2012 7.21