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

2 votes194 views1 answer
Sqlite show table indexes
SQL
13 votes158 views2 answers
Oracle all source
SQL
0 vote243 views1 answer
Create table like sql
SQL
0 vote201 views1 answer
Show the colums of table sql
SQL
13 votes218 views4 answers
Command line mysql import
SQL
0 vote210 views1 answer
Oracle change password expiration policy
SQL
3 votes251 views2 answers
@sqlresultsetmapping
SQL
0 vote209 views1 answer
SqlFunction does not exist
SQL
0 vote205 views1 answer
Guid string to binary better
SQL
-1 vote219 views1 answer
Utf8_encode mysql
SQL