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 vote181 views1 answer
Oracle query to see what scema i am working in
SQL
0 vote183 views1 answer
Mysql select distinct date from timestamp
SQL
0 vote187 views1 answer
Sql stored procedure update if parameter is not null
SQL
0 vote190 views1 answer
Excel export from sql using python
SQL
1 vote193 views1 answer
Alter constraint in sql
SQL
0 vote227 views1 answer
Sql select merge multiple values
SQL
0 vote259 views1 answer
SQL Server Altering Column to be Unique
SQL
0 vote195 views1 answer
Sql query interview questions githu
SQL
0 vote187 views1 answer
Renommer table sql
SQL
0 vote171 views1 answer
Cannot truncate a table referenced in a foreign key constraint (`video_clips`.`channel_clips`, CONSTRAINT `clips_fk` FOREIGN KEY (`clip_id`) REFERENCES `video_clips`.`clips` (`id`)) in sql]
SQL