Thursday, April 11, 2019

How to get all schema details on oracle database 18c?

Question : How to get all schema details on oracle database18c ?

Answer : use below query to get all schema details.

Query : select username from dba_users order by username;

Output :
SQL> select username from dba_users order by username;

USERNAME
----------------------
TEST1
TEST2
TEST3
TEST4
TEST5
TEST6

TEST7



No comments:

Post a Comment

How can I restore Cassandra snapshots?