Recently in started using package development, a bag have more than one stored procedure, it opens at right view can only see in baotou and stored procedure invocation parameters, how to check a bag all the stored procedure?

CodePudding user response:

Right click - & gt; To check the package and inclusions

CodePudding user response:

The CREATE OR REPLACE PACKAGE test_pkg IS
PROCEDURE update_sal (e_name VARCHAR2, newsal NUMBER);
The FUNCTION ann_income (e_name VARCHAR2) RETURN NUMBER;
END;

Can only see the
I look at the inside of the stored procedure code

CodePudding user response:

CTRL + Alt + the right mouse button

CodePudding user response:

Literally open a SQL window, and then write a you that bag inside a stored procedure name, remember the prefix in baotou. Such as P_PACK. UP_, press CTRL + left mouse button to see baotou, CTRL + the right mouse button to see inclusions