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 vote270 views1 answer
Concat column value of same user in mysql
SQL
1 vote267 views1 answer
How to select random rows from table
SQL
2 votes292 views2 answers
Sql query to list all tables in a database sql server
SQL
0 vote350 views1 answer
Reset a table's identity column and remove test records
SQL
0 vote278 views1 answer
Group by sql not ordering issues
SQL
0 vote281 views1 answer
Firebird where
SQL
2 votes273 views1 answer
Oracle drop table free up space
SQL
3 votes303 views2 answers
Sqlite show table structure
SQL
0 vote282 views2 answers
Sqlite unique
SQL
11 votes271 views2 answers
Safe mode off mysql
SQL