Oracle Sql developer: Not showing source code of views, triggers, functions for Oracle RDB

Question

I am using Oracle Sql developer to access my Oracle RDB database. I have installed Oracle RDB extension for Sql developer.

I see there everything in object browser - tables, views, triggers, functions, procedures.

The problem is When i want to see source code of any of views, triggers and function/procedures by mouse double-click, Sql developer does not show source code, it does not show any error

Does anybody have any idea how to retrieve or see source code of those views, triggers and functions?

Thanks.

Answer 1

This is the method for details for an Oracle database in SQL Developer (it may be the same for the RDB extension but I cannot verify this - if it is not then I hope this will be valuable to someone looking for the answer for a pure-Oracle perspective).

To see the SQL for a VIEW:

1. In the connections pane, expand the connection.
2. Expand the Views sub-folder.
3. Click on the View you want details of.
4. In the main panel, this should now show details of the columns of the view.
5. At the top of the main panel are a series of tabbed panes; the right-most one is "SQL" and if you click on it then it will show the SQL for the view.

For TRIGGER, FUNCTION, PROCEDURE or most other objects, the method is the same just select the appropriate object type instead of VIEW but the default action at step 4 will be to show the source code for that object.