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 vote153 views1 answer
Mysql sleep connections
SQL
1 vote142 views1 answer
Sql auto timestamp
SQL
0 vote170 views1 answer
Command line mysql xampp
SQL
-1 vote180 views1 answer
How to Activate the database
SQL
2 votes149 views1 answer
How to make insert script from table in SQL server
SQL
0 vote148 views1 answer
How to print mysql query of codeigniter query builder
SQL
0 vote195 views2 answers
How to prevent sql injection in java
SQL
0 vote143 views1 answer
Heavy table in mysql
SQL
0 vote151 views1 answer
Sql find all different values in column
SQL
12 votes153 views2 answers
Delete all entries postgres
SQL