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

17 votes125 views6 answers
Current date in sql
SQL
9 votes128 views2 answers
Oracle all tables in schema
SQL
0 vote121 views2 answers
Homebrew nysql launch
SQL
16 votes135 views3 answers
Jwt secret key generator laravel
SQL
21 votes132 views4 answers
Add column mssql
SQL
9 votes135 views5 answers
Laravel to sql
SQL
0 vote121 views1 answer
Caused by: java.lang.RuntimeException: Unable to obtain credentials to communicate with the Cloud SQL API
SQL
1 vote126 views1 answer
Oracle create program if no exists
SQL
0 vote115 views1 answer
R2dbc-postgresqldriver dependency
SQL
0 vote134 views1 answer
Rows, INSERT INTO, Returning
SQL