How To Get A List Of Oracle Database Schemas?

Well, this is one of those circumstances, where your ability to answer this question will depend upon your user’s assigned security roles and what you actually want. 

To get a complete list, you will need to use the DBA_ administrator tables to which most of us will not have access.  In the very simple examples below, you may want to add a WHERE clause to eliminate the system schemas from the list, like ‘SYS’ and ‘SYSTEM,’ if you have access to them.

Example Administrator (DBA) Schema List

SELECT distinct OWNER as SCHEMA_NAME

FROM  DBA_OBJECTS

ORDER BY OWNER;

Example Administrator (DBA) Schema List Results Screenshot

Fortunately for the rest of us, there are All user tables, from which we can get a listing of the schemas to which we have access.

Example All Users Schema List

SELECT distinct OWNER as SCHEMA_NAME

FROM    ALL_OBJECTS

ORDER BY OWNER;

Example All Users Schema List Results Screenshot

Related References

Oracle help Center > Database> Oracle > Oracle Database > Release 19

Oracle SQL*Plus Is still Around

It is funny how you cannot work with some for a while because of newer tools, and then rediscover them, so to speak.  The other day I was looking at my overflow bookshelf in the garage and saw an old book on Oracle SQL*Plus and was thinking, “do I still want or need that book?”. 

In recent years I have been using a variety of other tools when working with oracle. So, I really hadn’t thought about the once ubiquitous Oracle SQL*Plus command-line interface for Oracle databases, which around for thirty-five years or more.  However, I recently needed to do an Oracle 18C database install to enable some training and was pleasantly surprised Oracle SQL*Plus as a menu item. 

Now I have been purposely using Oracle SQL*Plus again to refresh my skills, and I will be keeping my Oracle SQL*Plus: The Definitive Guide, after all. 

How to Determine Your Oracle Database Name

Oracle provides a few ways to determine which database you are working in.  Admittedly, I usually know which database I’m working in, but recently I did an Oracle Database Express Edition (XE) install which did not goes has expected and I had reason to confirm which database I was actually in when the SQL*Plus session opened.  So, this lead me to consider how one would prove exactly which database they were connected to.  As it happens, Oracle has a few ways to quickly display which database you are connected to and here are two easy ways to find out your Oracle database name in SQL*Plus:

  • V$DATABASE
  • GLOBAL_NAME

Checking the GLOBAL_NAME table

The First method is to run a quick-select against the GLOBAL_NAME table, which. is publicly available to logged-in users of the database

Example GLOBAL_NAME Select Statement

select * from global_name;

Checking the V$DATABASE Variable

The second method is to run a quick-select a V$database. However, not everyone will have access to the V$database variable.

Example V$database Select Statement

select name from V$database;

How To write like it is your job

Writing and The Written Word

How to Write Like It Is Your Job

Many new writers come in the field with the mindset of “writing when inspiration strikes” or “writing what you understand.” Such myths deceive writers into thinking writing is not a job. Well, to build a career as a writer, you need to learn how to write like it is your job. A good starting point is doing away with away such myths.

On the other hand, what about others more experienced in writing? What fallacies and myths of the literary lifestyle can prevent you from writing like it is a job? Writing is not just a Job, it is also a business, and should such have a strategy and business plan to ensure career and personal success. It is vital for writing professionals to know the distinction of how essential a “job” is and…

View original post 1,681 more words

5 Basic Types of Blogs

Writing and The Written Word

If you’re new to blogging and are seeking to grow your audience, or have been doing it for a while now, then you understand the challenge of creating unique, compelling, and valuable content for your readers and potential leads. This is, perhaps, one of the main pain points of blogging. So, how can you ensure that you continually produce content that catches the reader’s attention, build their trust, and increase your conversions?

One way is to use different kinds of posts. By varying the format of your delivery, you can take charge of how well the content resonates with your readers/audience. This post will look at the different categories of blogs, their main characteristics and how you can use the various types of blog content to inspire variety on your website or blog.

Let’s dive in!

5 Different Types of Blog Content to Inspire Your…

View original post 709 more words

How You Can Leverage Pronouns To Improve Your Blog Article SEO

Writing and The Written Word

Search Engine Optimization (SEO) Search Engine Optimization (SEO)

Despite all the hype around search engine optimization (SEO), there are some very simple things that a writer can do while creating their blog posts which will improve their SEO and in some ways make the blog procedure read. Perhaps, the easiest way to do this is to replace pronouns with the actual name of the person object or subject being described or discussed. Instead of saying ‘it’, say car, barn, bus, or whatever ‘it’ refers to. With a little practice and some careful editing this is a simple approach which can add much SEO value to your writing.

Table of Pronouns

Here’s a quick list of pronouns to consider when writing and editing your blog post. This table of pronouns is by no means complete but it is an excellent starting point for some quick wins.

Subject
Pronoun

Object
Pronoun

Possessive
Adjective (Determiner)

Number

Gender

Person

I

me

my

singular

Neutral

first

View original post 216 more words

Why You Should Post Blogs Regularly

Writing and The Written Word

Just as we refuel our car engines every time they are almost empty, the blogs you post on your site perform the same function. It is the medium of attracting more traffic, sure way to get new visitors to your site, and a chance to create a strong social media presence. As a result, regular posting of blogs on your site is the backbone towards a successful blogging experience.

Unfortunately, many bloggers and website owners believe blogging works like billboard advertising. They only post few quality contents and then relax expecting magic to bring their website to the limelight. This concept doesn’t work anymore. Instead, you’d need to make regular editing, promote the contents, and most importantly, add more quality contents to your blog.

When you post content regularly, it strengthens your website by ranking higher in SEO. Based on the numerous factors search…

View original post 1,100 more words