How to display databases in Oracle 11g using SQL Plus

0 votes
I can see MySQL databases by using the command show databases.

How does Oracle display the accessible databases?
Sep 11 in Database by Kithuzzz
• 12,240 points
51 views

1 answer to this question.

0 votes

A MySQL "database" can be compared to an Oracle schema or user. You can search the DBA USERS view to see a list of schemas if you have the necessary privileges:

SELECT * FROM DBA_USERS;

I hope this helps you. 

answered Sep 12 by narikkadan
• 20,880 points

Related Questions In Database

0 votes
1 answer

How to rename a column in a database table using SQL?

For SQL Server, use sp_rename USE AdventureWorks; GO EXEC sp_rename 'Customers.CustomerTerritory.TerritoryID', ...READ MORE

answered Feb 9 in Database by Neha
• 8,920 points
106 views
0 votes
0 answers

How to display employee names starting with a and then b in sql

I want to display the names of ...READ MORE

Aug 12 in Database by Kithuzzz
• 12,240 points
46 views
0 votes
0 answers

How to create a small and simple database using Oracle 11 g and SQL Developer?

How can I build a tiny, straightforward ...READ MORE

Aug 20 in Database by Kithuzzz
• 12,240 points
39 views
0 votes
0 answers

How to display two digits after decimal point in SQL Server?

I want to return the value of ...READ MORE

Aug 26 in Database by Kithuzzz
• 12,240 points
34 views
0 votes
0 answers

PL/SQL ORA-01422: exact fetch returns more than requested number of rows

I am getting this error: DECLARE * ERROR at line ...READ MORE

Aug 19 in Database by Kithuzzz
• 12,240 points
58 views
0 votes
1 answer
0 votes
1 answer

ORA-01017 Invalid Username/Password when connecting to 11g database from 9i client

The user and password are DEFINITELY incorrect ...READ MORE

answered Feb 22 in Others by Aditya
• 7,660 points
271 views
0 votes
0 answers

Scott account locked in SQL Plus

Scott is my username and tiger is ...READ MORE

Aug 9 in Database by Kithuzzz
• 12,240 points
42 views
0 votes
1 answer

How can I confirm a database is Oracle & what version it is using SQL?

Run this SQL: select * from v$version; Output: BANNER ---------------------------------------------------------------- Oracle Database ...READ MORE

answered Sep 12 in Database by narikkadan
• 20,880 points
30 views
0 votes
1 answer

How to extract only the year from the date in sql server 2008?

To obtain the year from the given ...READ MORE

answered Sep 15 in Database by narikkadan
• 20,880 points
46 views
webinar REGISTER FOR FREE WEBINAR X
REGISTER NOW
webinar_success Thank you for registering Join Edureka Meetup community for 100+ Free Webinars each month JOIN MEETUP GROUP