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

0 vote255 views1 answer
For select oracle
SQL
0 vote209 views1 answer
Show create table in postgresql
SQL
0 vote215 views1 answer
Tsql cmd exec script from file
SQL
0 vote217 views1 answer
Get number of tables in database sql
SQL
0 vote204 views1 answer
SQL > Manipulação de Tabelas > Constraint
SQL
0 vote215 views1 answer
Oracle list of long running queries
SQL
0 vote222 views1 answer
Postgres copy command
SQL
0 vote215 views1 answer
Redudancy in SQL
SQL
1 vote205 views1 answer
SQLSTATE[HY000] [2002]
SQL
42 votes234 views6 answers
Install beautifulsoup
SQL