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

3 votes119 views1 answer
Start mysql server linux terminal
SQL
0 vote129 views1 answer
Show function mysql
SQL
0 vote125 views2 answers
Search stored procedures
SQL
1 vote119 views1 answer
Sql insert for each distinct value
SQL
0 vote178 views1 answer
Parent and child link in mysql
SQL
0 vote135 views1 answer
How to find lowest in sql
SQL
0 vote138 views1 answer
Time mysql w3
SQL
0 vote139 views1 answer
Sql ignore
SQL
9 votes134 views1 answer
Oracle get table schema
SQL
3 votes143 views6 answers
DB::table('users')->get();
SQL