Schema confusion while clicking "Open Declaration"
915236Mar 28 2012 — edited Dec 30 2012Hi,
SQLDeveloper 3.1.07.42.
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.