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

8 votes164 views2 answers
Mysql get first x characters
SQL
3 votes196 views2 answers
Sqlite show table definition
SQL
1 vote185 views2 answers
How to install sql server management studio in ubuntu 18.04
SQL
0 vote360 views1 answer
Why do we need data structure in sql
SQL
0 vote180 views1 answer
Mysql group by range
SQL
0 vote176 views1 answer
Get date ISO in psql
SQL
0 vote198 views1 answer
Permission denied postgres \copy csv command line
SQL
23 votes160 views6 answers
How to create table in sql
SQL
2 votes175 views1 answer
Mysql change data type of column
SQL
1 vote145 views1 answer
Mysql see column types
SQL