Query to find the services in oracle database

Query to get create dba directory statements of dba directories present in the database

set lines 999
set pagesize 999
col NAME for a45
col NETWORK_NAME for a45
col CON_NAME for a10
select NAME, NETWORK_NAME, CON_ID from gv$services;
select NAME, NETWORK_NAME, CON_NAME from sys.v$active_services;  

Output of the above query will be similar to below.

NAME                                          NETWORK_NAME                                   CON_ID
--------------------------------------------- --------------------------------------------- ----------
PODBA4_srv                                    PODBA4_srv                                     3

NAME                                           NETWORK_NAME                                  CON_NAME
--------------------------------------------- --------------------------------------------- ----------
PODBA4_srv                                     PODBA4_srv                                    PODBA4