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

3 votes156 views2 answers
To_char sql
SQL
0 vote180 views1 answer
Postgres list all triggers
SQL
21 votes166 views5 answers
Oracle all tables
SQL
-1 vote176 views1 answer
How to change the auto increment in existing table mysql
SQL
0 vote174 views1 answer
Ajax error exception handeling
SQL
0 vote194 views1 answer
Show tables in cassandra cql
SQL
0 vote207 views1 answer
Grouping by email domain mysql
SQL
0 vote226 views1 answer
SQL Server Enterprise
SQL
0 vote126 views1 answer
Big query add table rows to another table
SQL
0 vote157 views1 answer
Sql query to select records entered in last 24 hours
SQL