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 vote173 views1 answer
Second last highest id in sql
SQL
3 votes159 views1 answer
How to check schema privileges in oracle
SQL
0 vote153 views1 answer
Postgresql where clause not working
SQL
0 vote165 views1 answer
Changing name of column and datatype in sql
SQL
2 votes103 views1 answer
Sql select in list
SQL
0 vote127 views1 answer
Oracle sysdba connect as another user
SQL
1 vote148 views1 answer
Sql only five first row
SQL
4 votes150 views1 answer
What are the data types in sql
SQL
18 votes157 views6 answers
Creating table in MySQL
SQL
2 votes192 views2 answers
Asp.net core with postgresql deploy on ubuntu
SQL