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

1 vote103 views1 answer
How to give access to database in postgresql server to another user
SQL
0 vote89 views4 answers
Forenkey code alchemy sql
SQL
0 vote103 views1 answer
Set mysql socket file docker windows
SQL
0 vote57 views1 answer
Mysql collation for all languages
SQL
0 vote115 views1 answer
Flask sqlalchemy session delete
SQL
3 votes94 views1 answer
Oracle sleep
SQL
11 votes110 views1 answer
Sql insert multiple rows from select
SQL
5 votes102 views1 answer
Add column table sql default value
SQL
2 votes132 views1 answer
Oracle insert or update
SQL
14 votes95 views3 answers
Delete all records from table except sql
SQL