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 vote167 views1 answer
With_for_update sqlalchemy
SQL
0 vote185 views1 answer
How to make case insensitive in sql
SQL
0 vote192 views1 answer
Delete a temporary table mysql
SQL
1 vote168 views1 answer
Oracle select first result
SQL
3 votes178 views1 answer
How to uninstall microsoft sql server
SQL
0 vote185 views1 answer
Postgres list all stored procedures query
SQL
1 vote182 views2 answers
Begin transaction in sql
SQL
0 vote158 views1 answer
Sql from null to not null
SQL
2 votes171 views1 answer
Possgress drop if exists table
SQL
4 votes168 views3 answers
Drop Table Oracle
SQL