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

3 votes238 views2 answers
Oracle for loop
SQL
12 votes280 views6 answers
Distinct in sql server
SQL
0 vote272 views1 answer
How to generate ids in sql
SQL
13 votes249 views4 answers
Mysql access denied for user 'root'@'localhost'
SQL
0 vote256 views1 answer
Plpgsql coalesce equivalent for empty string
SQL
0 vote286 views2 answers
Clauses in mysql
SQL
0 vote259 views1 answer
Copy data from cell to cell mysql
SQL
0 vote240 views2 answers
Which MySQL statement is used to delete data from a database
SQL
20 votes264 views1 answer
Sql change column types
SQL
1 vote200 views1 answer
How to run sql script
SQL