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

11 votes150 views1 answer
Sql insert multiple rows from select
SQL
2 votes144 views1 answer
Mysql clear screen
SQL
0 vote148 views1 answer
Get max salary from each department sql
SQL
0 vote144 views1 answer
Oracle merge insert if not exists
SQL
0 vote147 views1 answer
Get date from timestamp in mysql
SQL
1 vote133 views1 answer
Moodle query item quiz
SQL
0 vote153 views1 answer
HOW to select specific table data from an mysql databse server:
SQL
15 votes144 views2 answers
Open postgress in terminal mac
SQL
2 votes158 views3 answers
Oracle show column of table
SQL
1 vote150 views1 answer
Show per page table in xampp
SQL