Checking the DB_LINK Connection

Question

I just created a DB link using the following query in oracle:

CREATE DATABASE LINK LINK_NAME
CONNECT TO DB_USERNAME
IDENTIFIED BY DB_USERNAME'S_PASSWORD
USING 'SERVICE_NAME';

and i'm able to see few more infos like owner,db_link,username,host,created details when viewed from sql developer.

How to use SELECT query in order to check the link connectivity to that DB_USERNAME or kindly suggest me a way to check the same ..

Answer 1

It's simple:

select * from dual@LINK_NAME