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 vote331 views1 answer
Capture Image Store Image in Folder and image Path in sqlite Database
SQL
1 vote343 views1 answer
Copy postgres table from one schema into another
SQL
0 vote347 views2 answers
Search stored procedures
SQL
4 votes332 views3 answers
Mysql update with join
SQL
0 vote349 views1 answer
Hibernate show sql xml property
SQL
0 vote378 views1 answer
Mysqldump: error:
SQL
4 votes351 views2 answers
Truncate oracle
SQL
35 votes345 views6 answers
Postgres
SQL
2 votes330 views1 answer
Oracle apex who is connected
SQL
0 vote353 views1 answer
Mysql grant grant option
SQL