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
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