How to view dblink information in PL/SQL?

To view information about the database link (dblink), you can use the following SQL statement:

SELECT *
FROM user_db_links; 

This query will return information about all database links that the current user has permission to access, including the link name, the database username associated with the link, and the database address of the link. If you want to view database link information for all users, you can use the following SQL statement:

SELECT *
FROM dba_db_links;

Please note that you need to have the appropriate permissions to query the user_db_links and dba_db_links views.