How to view stored procedures in oracle

Method: 1. Use the "SELECT text FROM user_source WHERE NAME = 'stored procedure name' ORDER BY line" statement to view; 2. Use pl/sql third-party tools to view, find the corresponding stored procedure and click to view Can.

The operating environment of this tutorial: Windows 10 system, Oracle 11g version, Dell G3 computer.

How to view stored procedures in oracle

You can view them with statements or use third-party tools.

1. Statement viewing method:

1. Execute statement:

SELECT text
    FROM user_source
   WHERE NAME = 'Procedure Name'
ORDER BY line;--其中Procedure Name为存储过程名字，需要全部用大写英文。

2. If you want to check the stored procedure of P_TEST:

SELECT text
    FROM user_source
   WHERE NAME = 'P_TEST'
ORDER BY line;

3. Content As follows:

2. Tool view:

1. Log in to the specified database with a third-party tool (such as pl/sql).

#2. Find Procedures in the tree on the left, and then find the corresponding stored procedure.

#3. Right-click the stored procedure and select "View". Then you can see it.

Recommended tutorial: "Oracle Tutorial"

The above is the detailed content of How to view stored procedures in oracle. For more information, please follow other related articles on the PHP Chinese website!