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

1 vote187 views2 answers
One to one and one to many relationship
SQL
0 vote167 views1 answer
Job for mysql.service failed because the control process exited with error code.
SQL
31 votes188 views4 answers
How to get duplicate records with multiple field in sql
SQL
3 votes177 views1 answer
Search for column name in psql
SQL
0 vote177 views1 answer
Less mysql display
SQL
1 vote173 views1 answer
Psql connections
SQL
1 vote190 views1 answer
Continue in sql
SQL
2 votes188 views1 answer
How to insert string variable into sqlite database
SQL
0 vote181 views1 answer
Mysql check datetime equals date
SQL
1 vote172 views1 answer
User privileges postgresql information_schema
SQL