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

6 votes137 views3 answers
How to delete table sqlite
SQL
0 vote152 views1 answer
Compress sql file database ubuntu
SQL
6 votes170 views2 answers
Oracle compile trigger
SQL
6 votes148 views1 answer
T-sql test if table exists
SQL
0 vote132 views1 answer
Check if table exists oracle
SQL
16 votes157 views1 answer
Mysql smallint range
SQL
0 vote143 views1 answer
Sql query for select from specific columns in a table
SQL
5 votes142 views1 answer
Oracle nls session
SQL
0 vote171 views1 answer
Php insert null mysql
SQL
0 vote167 views1 answer
Flask sqlalchemy session delete
SQL