How do I get the total number of databases that are active?Alter in PL SQL LoopHow can I count the total...

What is the meaning of "usr"?

Trying to use an LCD 1602 to display, but I don't have a 10 KOhm potentiometer

How can I differentiate duration vs starting time

In the Lost in Space intro why was Dr. Smith actor listed as a special guest star?

How do I narratively explain how in-game circumstances do not mechanically allow a PC to instantly kill an NPC?

How can I keep my gold safe from other PCs?

Is there a way to pause a running process on Linux systems and resume later?

What could cause an entire planet of humans to become aphasic?

Would water spill from a bowl in a Bag of Holding?

Why write a book when there's a movie in my head?

Why does a single AND gate need 60 transistors?

Inversion applicable to three-dimensional lattices only

What does "south of due west" mean?

How do I fight with Heavy Armor as a Wizard with Tenser's Transformation?

What is an explicit bijection in combinatorics?

Buying a "Used" Router

Why do single electrical receptacles exist?

Is the UK legally prevented from having another referendum on Brexit?

Is it possible to methodically find the total of ways to read a given phrase making a stack?

Is there any danger of my neighbor having my wife's signature?

What does an unprocessed RAW file look like?

Including proofs of known theorems in master's thesis

filecontents: select rows of group to display

When does a person lose diplomatic status?



How do I get the total number of databases that are active?


Alter in PL SQL LoopHow can I count the total number of document indexed by my oracle.text index?Monitoring multiple Oracle databases on a single screenOracle Enterprise Manager InstallationHow to get current time in Oracle, and use in interval partition?CMD prompt can't display Unicode characters that are stored in oracle database correctlyHow to prompt sql if there is no exceptionUsing group by with an array in oracleHow to identify the destination host of active database links?ORA-19815, ORA-01031 and ORA-12514 error













0















I am learning Oracle and I am trying to figure out (in command prompt) the total number of databases that are up.



I tried




select name from v$database











share|improve this question







New contributor




software is fun is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.

























    0















    I am learning Oracle and I am trying to figure out (in command prompt) the total number of databases that are up.



    I tried




    select name from v$database











    share|improve this question







    New contributor




    software is fun is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
    Check out our Code of Conduct.























      0












      0








      0








      I am learning Oracle and I am trying to figure out (in command prompt) the total number of databases that are up.



      I tried




      select name from v$database











      share|improve this question







      New contributor




      software is fun is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
      Check out our Code of Conduct.












      I am learning Oracle and I am trying to figure out (in command prompt) the total number of databases that are up.



      I tried




      select name from v$database








      oracle tnsnames tns






      share|improve this question







      New contributor




      software is fun is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
      Check out our Code of Conduct.











      share|improve this question







      New contributor




      software is fun is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
      Check out our Code of Conduct.









      share|improve this question




      share|improve this question






      New contributor




      software is fun is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
      Check out our Code of Conduct.









      asked 13 mins ago









      software is funsoftware is fun

      1032




      1032




      New contributor




      software is fun is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
      Check out our Code of Conduct.





      New contributor





      software is fun is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
      Check out our Code of Conduct.






      software is fun is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
      Check out our Code of Conduct.






















          0






          active

          oldest

          votes











          Your Answer








          StackExchange.ready(function() {
          var channelOptions = {
          tags: "".split(" "),
          id: "182"
          };
          initTagRenderer("".split(" "), "".split(" "), channelOptions);

          StackExchange.using("externalEditor", function() {
          // Have to fire editor after snippets, if snippets enabled
          if (StackExchange.settings.snippets.snippetsEnabled) {
          StackExchange.using("snippets", function() {
          createEditor();
          });
          }
          else {
          createEditor();
          }
          });

          function createEditor() {
          StackExchange.prepareEditor({
          heartbeatType: 'answer',
          autoActivateHeartbeat: false,
          convertImagesToLinks: false,
          noModals: true,
          showLowRepImageUploadWarning: true,
          reputationToPostImages: null,
          bindNavPrevention: true,
          postfix: "",
          imageUploader: {
          brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
          contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
          allowUrls: true
          },
          onDemand: true,
          discardSelector: ".discard-answer"
          ,immediatelyShowMarkdownHelp:true
          });


          }
          });






          software is fun is a new contributor. Be nice, and check out our Code of Conduct.










          draft saved

          draft discarded


















          StackExchange.ready(
          function () {
          StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fdba.stackexchange.com%2fquestions%2f230571%2fhow-do-i-get-the-total-number-of-databases-that-are-active%23new-answer', 'question_page');
          }
          );

          Post as a guest















          Required, but never shown

























          0






          active

          oldest

          votes








          0






          active

          oldest

          votes









          active

          oldest

          votes






          active

          oldest

          votes








          software is fun is a new contributor. Be nice, and check out our Code of Conduct.










          draft saved

          draft discarded


















          software is fun is a new contributor. Be nice, and check out our Code of Conduct.













          software is fun is a new contributor. Be nice, and check out our Code of Conduct.












          software is fun is a new contributor. Be nice, and check out our Code of Conduct.
















          Thanks for contributing an answer to Database Administrators Stack Exchange!


          • Please be sure to answer the question. Provide details and share your research!

          But avoid



          • Asking for help, clarification, or responding to other answers.

          • Making statements based on opinion; back them up with references or personal experience.


          To learn more, see our tips on writing great answers.




          draft saved


          draft discarded














          StackExchange.ready(
          function () {
          StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fdba.stackexchange.com%2fquestions%2f230571%2fhow-do-i-get-the-total-number-of-databases-that-are-active%23new-answer', 'question_page');
          }
          );

          Post as a guest















          Required, but never shown





















































          Required, but never shown














          Required, but never shown












          Required, but never shown







          Required, but never shown

































          Required, but never shown














          Required, but never shown












          Required, but never shown







          Required, but never shown







          Popular posts from this blog

          Szabolcs (Ungheria) Altri progetti | Menu di navigazione48°10′14.56″N 21°29′33.14″E /...

          Discografia di Klaus Schulze Indice Album in studio | Album dal vivo | Singoli | Antologie | Colonne...

          How to make inet_server_addr() return localhost in spite of ::1/128RETURN NEXT in Postgres FunctionConnect to...