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 vote145 views1 answer
Display all node label neo4j
SQL
0 vote104 views1 answer
Hibernate dialect property xml for mysql 8
SQL
29 votes99 views6 answers
Delete all rows from table mysql
SQL
3 votes101 views4 answers
Psql list tables in schema
SQL
0 vote119 views1 answer
Query archive mode
SQL
8 votes110 views1 answer
Script to add datafile to tablespace
SQL
0 vote113 views1 answer
Sql include rows with 0 values
SQL
0 vote103 views1 answer
Postgresql parse json array
SQL
6 votes155 views2 answers
How to get last element sql
SQL
2 votes116 views1 answer
Merge firstname and lastname in sql oracle
SQL