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

24 votes267 views6 answers
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)
SQL
0 vote336 views1 answer
Set engine to innodb
SQL
0 vote317 views3 answers
Joins and views sql
SQL
14 votes340 views2 answers
Oracle limit rows
SQL
0 vote311 views1 answer
How to fix mysql stop unexpectedly
SQL
0 vote350 views2 answers
Coursera spark sql max count
SQL
12 votes334 views4 answers
Psql command not found
SQL
0 vote316 views1 answer
Copy Table from SQL to CSV
SQL
4 votes318 views2 answers
Convert utc to est sql
SQL
2 votes276 views1 answer
Sql select in list
SQL