how to get service name in oracle code example Example: oracle service name view select name from V$SERVICES; select name from V$ACTIVE_SERVICES;