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

0 vote388 views1 answer
Mysql where sum > 0
SQL
4 votes342 views3 answers
Postgres set default value
SQL
3 votes369 views1 answer
Only join in sql
SQL
0 vote340 views1 answer
Mysql cdn link
SQL
3 votes349 views4 answers
Stop MySQL
SQL
-1 vote357 views2 answers
Postgresql user permissions to database
SQL
7 votes397 views1 answer
Buy forge mods server hosting
SQL
0 vote375 views1 answer
Postgresql list extensions
SQL
2 votes352 views1 answer
Sql to char function with date
SQL
0 vote365 views1 answer
Sql today at midnight
SQL