Follow us: Connect on YouTube Connect on YouTube Connect on YouTube


Thursday, 16 June 2016

Query to get Database Links

SELECT owner            "Owner"
,      db_link          "Link Name"
,      username         "Username"
,      created          "Created"
,      host             xonly_host
FROM   all_db_links
Share this article :


  1. Hi Dayakar,

    What a brilliant post I have come across and believe me I have been searching out for this similar kind of post for past a week and hardly came across this.

    I am using Microsoft Visual Studio 2015 (as SSDT) to develop a cube on SQL 2014 standard edition with Analysis Services installed in Multidimensional mode.
    The cube gets deployed to Analysis Services and also gets processed without errors. I can browse the cube from SSMS, but cannot brows it from Visual Studio Cube browser. The error I am getting is :
    "Errors related to feature availability and configuration: The 'Tabular View' feature is not included in the '64 Bit Standard' edition of Analysis Services. (Microsoft SQL Server 2014 Analysis Services)
    Why is it trying to browse in Tabular view? How do i set it to browse in Multidimensional view?

    I look forward to see your next updates.

    Thanks a heaps,

  2. Hello There,

    Fully agree on Query to get Database Links. We’re seeing a lot of projects tackle big complex problems but few seem to have taken into consideration and in particular reasons to adopt.

    I want to execute the different files at the run time in the SQL PLUS

    Ex: I have two different files like ABC.SQL, XYZ.SQL,

    I had declared one bind variable to hold file_name .

    var file_name VARCHAR2(200);
    sr VARCHAR2(20) :='ABC';
    IF sr ='ABC' THEN
    :file_name :='ABC.SQL';
    :file_name :='XYZ.SQL';
    END IF;
    PRINT file_name

    Now i want to execute the file which is there in :file_name bind variable


    It was cool to see your article pop up in my google search for the process yesterday. Great Guide.
    Keep up the good work!


  3. Selamat Petang,

    The challenge however, is we don’t yet know how it will be used making to hard to assess their value proposition and consequently value.

    how to apply refcursor in package with multiple insted of multple cursors in oracle?
    Give one example.
    Thank you very much and will look for more postings from you.


  4. Hi There,

    Interesting piece!Great to see someone write Query to get Database Links who is not a fanatic or a complete skeptic

    I was trying to retrieve all the columns names from over 100 different views in an oracle database earlier today. I wasn't quite sure how to do it, so to save time I used query to get all the view names, then simply wrote a query that selected the view name and column names from all views where view_name in (list of views).

    I was thinking about writing looping through all the view_names in the database and for each iteration storing the column_names in a variable and the outputting this to the screen.

    As each view can have differing number of columns though would I have to store the column names in a record variable?

    Then how would I retrieve the column names for each view name stored in this record variable?

    Very useful article, if I run into challenges along the way, I will share them here.


  5. If you're getting one from a site about cars when your site is all about puppies, Google is likely going to discount the influence that it has as it is very likely that you created that link yourself because typically a webmaster of a car site would not link to your puppy themed site on their own. twitter link shortener

  6. This is such a great resource that you are providing and you give it away for free. pbn links for sale

  7. Oracle apps and Fusion Self Paced Training Videos by Industry Experts. Please Check

  8. Oracle Apps R12 and Oracle Fusion Cloud Self Paced Online Training Videos Published on Udemy with Life Time Access & Live Meeting Support to Clear your Queries. Avail 25% to 80% discount. Please Check for Never Before Offers and Discount Coupon Codes.

  9. Two full thumbs up for this magneficent article of yours. I've really enjoyed reading this article today and I think this might be one of the best article that I've read yet. Please, keep this work going on in the same quality. online energy drink shopping

  10. If you find it useful to determine which database link connections are currently open in your session, You can query a table or view on the other database with the SELECT statement. And mostly access to more bottom like INSERT, UPDATE, DELETE Etc, Well I am a professional logo designer in USA and I have 5 years working experiance.