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

6 votes284 views1 answer
To count number of rows in SQL table
SQL
1 vote308 views1 answer
Oracle previous year
SQL
0 vote284 views1 answer
Sqlite3 get data from table c
SQL
1 vote313 views3 answers
Sql procedure
SQL
0 vote281 views2 answers
Show slave status mysql
SQL
0 vote292 views1 answer
Mostrar datos de tablas relacionadas mysql kjava
SQL
16 votes335 views3 answers
T-SQL Add Column
SQL
0 vote316 views1 answer
Updating database in sql
SQL
0 vote285 views1 answer
Mysql date only no time
SQL
10 votes268 views1 answer
Oracle dependency
SQL