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

Pages

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
ORDER BY 1,2
Share this article :

5 comments:

  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,
    Morgan

    ReplyDelete
  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);
    DECLARE
    sr VARCHAR2(20) :='ABC';
    BEGIN
    IF sr ='ABC' THEN
    :file_name :='ABC.SQL';
    ELSE
    :file_name :='XYZ.SQL';
    END IF;
    END;
    /
    PRINT file_name

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

    SQL>@:file_name

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

    Obrigado,
    Preethi

    ReplyDelete
  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.

    Regards,
    Radhey

    ReplyDelete
  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.

    Shukran,
    Preethi.

    ReplyDelete
  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

    ReplyDelete