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 vote455 views1 answer
Multiple row join
SQL
1 vote284 views3 answers
Get all tables postgres
SQL
-1 vote313 views1 answer
Ms sql select datetime as date
SQL
1 vote278 views1 answer
How to change owner in postgres
SQL
1 vote261 views1 answer
Sql try catch
SQL
1 vote262 views1 answer
Psql connect to another database
SQL
0 vote264 views1 answer
Alter table name including schema
SQL
1 vote264 views1 answer
How to select department from table
SQL
2 votes265 views6 answers
In in sql
SQL
0 vote279 views1 answer
Top frequency in sql server
SQL