private string GetDDLForTable(string tableName, string owner) { using (System.Data.OracleClient.OracleConnection conn = new System.Data.OracleClient.OracleConnection(strCon1)) { System.Data.OracleClient.OracleCommand cmd = conn.CreateCommand(); cmd.CommandText = string.Format("select SYS.DBMS_METADATA.GET_DDL('TABLE','{0}','{1}') from dual", tableName, owner); conn.Open(); object result = cmd.ExecuteScalar(); return(result.ToString()); } }
public void InsertRecord(string SQLStatement) { if (SQLStatement.Length > 0) { if (connOracle.State.ToString().Equals("Open")) { sqlCommandOracle = new System.Data.OracleClient.OracleCommand(SQLStatement, connOracle); sqlCommandOracle.ExecuteScalar(); } } }
public object ExecuteScalar() { return(_cmd.ExecuteScalar()); }