Oracle list service names

SELECT VALUE FROM V$PARAMETER WHERE NAME = 'service_names';
SELECT NAME FROM V$SERVICES;
SELECT NAME FROM V$ACTIVE_SERVICES;
SELECT * FROM ALL_SERVICES;

Oracle service name view

select name from V$SERVICES;
select name from V$ACTIVE_SERVICES;

Source: stackoverflow.com

Similar codes

5 votes209 views2 answers
Oracle list columns
SQL
0 vote202 views2 answers
Timing sql queries
SQL
0 vote184 views1 answer
Sqldf change user
SQL
1 vote199 views1 answer
Mysql return if it contains
SQL
1 vote198 views4 answers
Mysqldump 1 table only
SQL
1 vote190 views2 answers
Duplicate key value violates unique constraint "django_admin_log_pkey"
SQL
2 votes186 views1 answer
Sqlite show table indexes
SQL
0 vote181 views1 answer
Restore backup "text" postgresql command line
SQL
1 vote190 views1 answer
Sometimes i cant edit sql developer
SQL
0 vote198 views1 answer
Mariadb mysql root access denied
SQL