/* * 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