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 votes231 views3 answers
Psql show columns of table
SQL
0 vote239 views2 answers
Reduce size of SQL server log file truncate - Source :NAYCode.com
SQL
1 vote134 views1 answer
Primary key with prefix sql
SQL
0 vote138 views2 answers
How to find sql server agent jobs related to a database
SQL
-1 vote136 views1 answer
Convert google analytics dathourminute to time stamp? sql
SQL
0 vote79 views1 answer
FindAllBy
SQL
0 vote121 views1 answer
Cara menampilkan user di mysql terminal
SQL
0 vote142 views1 answer
Rename constraint postgresql
SQL
10 votes135 views4 answers
Drop primary key
SQL
9 votes141 views2 answers
Convert data type in sql
SQL