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 vote208 views2 answers
Script all indexes in a database
SQL
0 vote220 views1 answer
Mariadb change column type
SQL
1 vote210 views1 answer
Sql first day quarter
SQL
0 vote223 views1 answer
Cube oracle
SQL
0 vote203 views1 answer
Power bi dax add related shows column but not working
SQL
4 votes242 views1 answer
Fatal error: libpq-fe.h: No such file or directory
SQL
0 vote213 views1 answer
Utiliser sql ligne de commande
SQL
0 vote211 views1 answer
Convert excel into sqllite db using python
SQL
10 votes200 views4 answers
Mysql one week ago
SQL
0 vote209 views1 answer
Select STR_TO_DATE(date_seance1,'DD-MM-YYYY')
SQL