Query to view links that you own - Administering and Managing an Oracle Database

Q.  Select the correct query to view the links that you own.
- Published on 30 Jul 15

a. select db_link from user_db_links;
b. select _link from user_db_links;
c. select db_link from dblinks;
d. select link from user_db_links;

ANSWER: select db_link from user_db_links;

Related Content

 

    Discussion

  • Nirja Shah   -Posted on 27 Aug 15
    - A database link is a connection between two physical database servers that allows a client to access them as one logical database.

    - USER_DB_LINKS - It describes the database links owned by the current user.
    - Its columns are the same as those in ALL_DB_LINKS except that it does not have the OWNER column.
    - It also displays an additional column, PASSWORD, which is no longer used and for which nothing is returned. The PASSWORD column is maintained for backward compatibility only.

➨ Post your comment / Share knowledge


Enter the code shown above:

(Note: If you cannot read the numbers in the above image, reload the page to generate a new one.)
▲