There is only so much you can do to make this portable to other database platforms such as Oracle. Reason is that Oracle handles things like databases and schemas much differently than mySQL.

In Oracle you will need to connect to each database/instance as a user/schema with DBA privileges and submit a query to list all of the users/schemas. Without an existing account and an existing database you won't get very far.

Actually, if you only wanted a list of databases/instances you could load and parse the /etc/oratab file. This file contains a list of all oracle databases on the host, along with their respective ORACLE_HOME locations, and whether or not they should startup or shutdown automatically. This would give you your database list but you'd still have to connect as a user to get a user list.

HTH

In reply to Re: Checking installed MySQL databases with DBI by elwarren
in thread Checking installed MySQL databases with DBI by fpi

Title:
Use:  <p> text here (a paragraph) </p>
and:  <code> code here </code>
to format your post, it's "PerlMonks-approved HTML":


  • Posts are HTML formatted. Put <p> </p> tags around your paragraphs. Put <code> </code> tags around your code and data!
  • Titles consisting of a single word are discouraged, and in most cases are disallowed outright.
  • Read Where should I post X? if you're not absolutely sure you're posting in the right place.
  • Please read these before you post! —
  • Posts may use any of the Perl Monks Approved HTML tags:
    a, abbr, b, big, blockquote, br, caption, center, col, colgroup, dd, del, details, div, dl, dt, em, font, h1, h2, h3, h4, h5, h6, hr, i, ins, li, ol, p, pre, readmore, small, span, spoiler, strike, strong, sub, summary, sup, table, tbody, td, tfoot, th, thead, tr, tt, u, ul, wbr
  • You may need to use entities for some characters, as follows. (Exception: Within code tags, you can put the characters literally.)
            For:     Use:
    & &amp;
    < &lt;
    > &gt;
    [ &#91;
    ] &#93;
  • Link using PerlMonks shortcuts! What shortcuts can I use for linking?
  • See Writeup Formatting Tips and other pages linked from there for more info.