/*
* SELECT VARIABLE_NAME, VARIABLE_VALUE FROM INFORMATION_SCHEMA.GLOBAL_VARIABLES WHERE VARIABLE_NAME = 'VERSION'
*
* 1) To view database
*
* select * from v$database;
*
* 2) To view instance
*
* select * from v$instance;
*
* 3) To view all users
*
* select * from all_users;
* http://nixcraft.com/databases-servers/1971-oracle-show-databases-list.html
*/
// http://www.coderanch.com/t/80812/Oracle-OAS/list-all-databases-Oracle
public System.Data.DataTable GetDataBases(dbOwner ShowDBs)
{
string strSQL = @"
select * from user_tablespaces;
";
/*
* if ((uint)(ShowDBs & dbOwner.user) != 0)
* {
* strSQL += @"
* WHERE owner_sid != 0x01
* ";
* }
*
* strSQL += @"
* ORDER BY name ASC
* ";
*/
//string strOldInitialCatalog = this.m_ConnectionString.InitialCatalog;
//this.m_ConnectionString.InitialCatalog = "master";
System.Data.DataTable dt = GetDataTable(strSQL);
//this.m_ConnectionString.InitialCatalog = strOldInitialCatalog;
//strOldInitialCatalog = null;
return(dt);
} // End Function GetDataBases
public override string GetDataBasesQueryText(dbOwner ShowDBs)
{
string strSQL = @"
SELECT
name
,owner_sid
,create_date
,compatibility_level
,collation_name
FROM sys.databases
";
if ((uint)(ShowDBs & dbOwner.user) != 0)
{
strSQL += @"
WHERE owner_sid != 0x01
";
}
strSQL += @"
ORDER BY name ASC
";
return(strSQL);
}
public override string GetDataBasesQueryText(dbOwner ShowDBs)
{
string strSQL = @"
SELECT
datname AS name
,datcollate AS collation_name
,NULL AS owner_sid
,NULL AS create_date
,0 AS compatibility_level
,datdba
,encoding
,datctype
,datistemplate
,datallowconn
,datconnlimit
,datlastsysoid
,datfrozenxid
,dattablespace
,datacl
FROM pg_database
WHERE datistemplate = false
ORDER BY datname ASC ;
";
return(strSQL);
}
/*
* SELECT VARIABLE_NAME, VARIABLE_VALUE FROM INFORMATION_SCHEMA.GLOBAL_VARIABLES WHERE VARIABLE_NAME = 'VERSION'
*/
// http://stackoverflow.com/questions/3499372/get-list-of-mysql-databases-and-server-version
public System.Data.DataTable GetDataBases(dbOwner ShowDBs)
{
string strSQL = @"
SELECT
schema_name AS Name
,
CASE WHEN schema_name IN ('mysql', 'information_schema', 'performance_schema')
THEN 0
ELSE 1
END AS Sort
FROM INFORMATION_SCHEMA.SCHEMATA
-- WHERE schema_name NOT IN ('mysql', 'information_schema', 'performance_schema')
ORDER BY Sort, Name
";
/*
* if ((uint)(ShowDBs & dbOwner.user) != 0)
* {
* strSQL += @"
* WHERE owner_sid != 0x01
* ";
* }
*
* strSQL += @"
* ORDER BY name ASC
* ";
*/
//string strOldInitialCatalog = this.m_ConnectionString.InitialCatalog;
//this.m_ConnectionString.InitialCatalog = "master";
System.Data.DataTable dt = GetDataTable(strSQL);
//this.m_ConnectionString.InitialCatalog = strOldInitialCatalog;
//strOldInitialCatalog = null;
return(dt);
} // End Function GetDataBases
} // End Sub GetDataBases
public System.Data.DataTable GetDataBases(dbOwner ShowDBs)
{
System.Data.DataTable dt = GetDataTable(GetDataBasesQueryText(ShowDBs), "master");
return(dt);
} // End Function GetDataBases
