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 vote350 views1 answer
Sql server datetime to string
SQL
2 votes330 views1 answer
Install sqlite npm
SQL
1 vote373 views1 answer
Find a column in all tables postgres
SQL
0 vote336 views1 answer
Mysql create table like
SQL
15 votes383 views6 answers
Laravel db transaction
SQL
0 vote340 views2 answers
How to find max and min salary in sql
SQL
0 vote370 views1 answer
Mysql drop trigger
SQL
0 vote346 views1 answer
Postgresql inline table
SQL
1 vote352 views1 answer
Insert column after column mysql
SQL
0 vote388 views1 answer
How to connect to xampp sql server on windows cmd
SQL