使用 sqlplus

sqlplus/as sysdba

运行:

选择 *来自 dba_users

您是否只希望用户名执行以下操作:

选择用户名来自 dba_users

I wanted to delete some unused schemas on our oracle DB.

How can I query for all schema names ?

Using sqlplus

sqlplus / as sysdba

run:

SELECT * 
FROM dba_users

Should you only want the usernames do the following:

SELECT username 
FROM dba_users