Warm tip: This article is reproduced from stackoverflow.com, please click
oracle oracle-sqldeveloper

How to view synonym procedure in sql developer?

发布于 2021-01-07 03:37:19

I have a procedure, function synonym from production environment. When i search with name in sql developer it shows in a list, but when i click to view it just show CREATE synonym statement only not a code. But in TOAD it will show by pressing F4 key i think.

How i able to view that synonym procedure in SQL developer tool?

Questioner
Nvr
Viewed
0
thatjeffsmith 2020-09-03 21:57

Place your cursor on the syn name in your pl/sql block.

Right click, Popup DESC

This will open the underlying PL/SQL program, in this case, a procedure in my schema.

enter image description here