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 vote314 views1 answer
Cannot insert duplicate key in object 'dbo.Instructor'. The duplicate key value is (2).
SQL
7 votes311 views1 answer
Sql management studio display line numbers
SQL
0 vote324 views1 answer
Oracle procedure chain step
SQL
0 vote339 views1 answer
Sql cnvert bit to nvarchar
SQL
2 votes325 views1 answer
Set boolean flasksql
SQL
32 votes345 views6 answers
Sql count where
SQL
10 votes324 views6 answers
Mysql delete duplicates
SQL
0 vote329 views1 answer
Create table as select sql server error
SQL
0 vote322 views1 answer
Get employees if not contains in sql
SQL
0 vote323 views1 answer
Select odd records sql
SQL