Oracle PL/SQL Tutorial/System Tables Data Dictionary/user libraries
Query user_libraries
SQL>
SQL>
SQL>
SQL> select library_name, file_spec, dynamic from user_libraries;
no rows selected
SQL>
SQL>
SQL>
SQL>
SQL>
SQL> select library_name, file_spec, dynamic from user_libraries;
no rows selected
SQL>
SQL>