View in Oracle query database

Select * From dba_views;
Select * From user_views;

Desc dba_source; DESC user_source;
Select text from user_source
Where name = 'your PKG name'
Order by line;
Union can remove duplicate records, but union all cannot.
In Oracle, how does one call a stored procedure? It is best to have specificCodeExample!
You can call the process name directly.
For example, p_test1 calls p_test2 (asret2 out varchar2)
Create or replace procedure p_test1 (
Astest in varchar2,
Asret out varchar2)
As
Asprocret varchar2 (100 );
...
Begin
P_test2 (asprocret );
End p_test1;

Write a PLSQL block and execute it in sqlplus.
Begin
Declare
Asparam varchar2 (10 );
Begin
P_test1 (asparam );
End;
End;