This discussion is archived
2 Replies Latest reply: Dec 30, 2012 5:01 AM by 915236 RSS

Schema confusion while clicking "Open Declaration"

915236 Newbie
Currently Being Moderated
Hi,
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.

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points