Search
 
SCRIPT & CODE EXAMPLE
 

SQL

oracle service name view

select name from V$SERVICES;
select name from V$ACTIVE_SERVICES;
Comment

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;
Comment
PREVIOUS NEXT
Code Example
Sql :: add sequence postgres 
Sql :: how to check last gather stats on table in oracle 
Sql :: revoke a role from user microsoft sql server 
Sql :: how to run mysql in git bash 
Sql :: add primary key constraint in oracle 
Sql :: oracle stop job 
Sql :: how to remove unique key constraint in mysql 
Sql :: insert column with default value in sql 
Sql :: grant lock tables privilege mysql 
Sql :: append column sql 
Sql :: mysql increment value by 1 in update 
Sql :: mysql not supported auth mode 
Sql :: mariadb show tables 
Sql :: create table if not exists postgresql 
Sql :: mysql created at yesterdau 
Sql :: set sequence value oracle 
Sql :: upload database mysql command line 
Sql :: mysql calculate age 
Sql :: postgresql pg_dump 
Sql :: rails run native ssql query 
Sql :: add new column to the table mysql 
Sql :: mac os zsh: command not found: mysql 
Sql :: age postgres 
Sql :: apex select list ORA-20999 
Sql :: sql delete records older than 1 day 
Sql :: sql server for loop 
Sql :: truncate left characters mysql 
Sql :: laravel paginate raw sql 
Sql :: différence entre deux dates sql oracle 
Sql :: psql import backup file for windows 
ADD CONTENT
Topic
Content
Source link
Name
5+4 =