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 vote162 views2 answers
Suse stop MySQL
SQL
9 votes125 views3 answers
Where in sql
SQL
0 vote133 views2 answers
Auto increment column in mysql query results
SQL
0 vote144 views1 answer
How to change mysql root password in windows 10
SQL
1 vote130 views6 answers
In sql
SQL
0 vote142 views1 answer
Oracle calculate statistics on partition
SQL
9 votes132 views3 answers
Sql delete where in
SQL
0 vote125 views2 answers
Sql last updated
SQL
1 vote130 views1 answer
Oracle check table space
SQL
0 vote133 views1 answer
How to check default value of column in sql server
SQL