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 :

10 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
  6. This is such a great resource that you are providing and you give it away for free. pbn links for sale

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

    ReplyDelete
  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 https://www.oracleappstechnical.com for Never Before Offers and Discount Coupon Codes.

    ReplyDelete
  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

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

    ReplyDelete