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

3 votes237 views2 answers
Mysql create timestamp column
SQL
5 votes255 views2 answers
Sql number columns
SQL
2 votes265 views2 answers
Mysql does sentence contain word
SQL
12 votes260 views4 answers
How to check mysql version ubuntu
SQL
0 vote251 views1 answer
Multiple replace value mssql
SQL
0 vote240 views1 answer
Mariadb select limit offset
SQL
1 vote274 views1 answer
Mysqld_safe Directory '/var/run/mysqld' for UNIX socket file don't exists.
SQL
2 votes258 views1 answer
Q operator in oracle
SQL
1 vote235 views1 answer
Postgres delete from where date is greater than specific date
SQL
14 votes250 views3 answers
Oracle sql limit results
SQL