INSERT INTO table_name VALUES (:col1, :col2, :col3, :col4, :col5)

 public void InsertDataRow(Dictionary<string, object> dataRow)

 {

 	StringBuilder sbCmdText = new StringBuilder();

 	sbCmdText.AppendFormat("INSERT INTO {0}(", m_TableName);

 	sbCmdText.Append(string.Join(",", dataRow.Keys.ToArray()));

 	sbCmdText.Append(") VALUES (");

 	sbCmdText.Append(":" + string.Join(",:", dataRow.Keys.ToArray()));

 	sbCmdText.Append(")");

 	using (OracleConnection conn = new OracleConnection())

 	{

 		using (OracleCommand cmd = conn.CreateCommand())

 		{

 			cmd.CommandType = CommandType.Text;

 			cmd.CommandText = sbCmdText.ToString();

 			OracleParameter parameter = null;

 			OracleDbType dbType = OracleDbType.Object;

 			foreach (string colName in dataRow.Keys)

 			{

 				dbType = GetOracleDbType(dataRow[colName]);

 				parameter = new OracleParameter(colName, dbType);

 				parameter.Direction = ParameterDirection.Input;

 				parameter.OracleDbTypeEx = dbType;

 				parameter.Value = dataRow[colName];

 				cmd.Parameters.Add(parameter);

 			}

 			conn.Open();

 			int result = cmd.ExecuteNonQuery();

 		}

 	}

 }

 /// <summary>

 /// 批量插入大数据量

 /// </summary>

 /// <param name="columnData">列名-列数据字典</param>

 /// <param name="dataCount">数据量</param>

 /// <returns>插入数据量</returns>

 public int InsertBigData(Dictionary<string, object> columnData, int dataCount)

 {

 	int result = 0;

 	if (columnData == null || columnData.Count < 1)

 	{

 		return result;

 	}

 	string[] colHeaders = columnData.Keys.ToArray();

 	StringBuilder sbCmdText = new StringBuilder();

 	if (columnData.Count > 0)

 	{

 		// 拼接INSERT的SQL语句

 		sbCmdText.AppendFormat("INSERT INTO {0}(", m_TableName);

 		sbCmdText.Append(string.Join(",", colHeaders));

 		sbCmdText.Append(") VALUES (");

 		sbCmdText.Append(m_ParameterPrefix + string.Join("," + m_ParameterPrefix, colHeaders));

 		sbCmdText.Append(")");

 		OracleConnection connection = null;

 		try

 		{

 			connection = new OracleConnection(GetConnectionString());

 			using (OracleCommand command = connection.CreateCommand())

 			{

 				command.ArrayBindCount = dataCount;

 				command.BindByName = true;

 				command.CommandType = CommandType.Text;

 				command.CommandText = sbCmdText.ToString();

 				command.CommandTimeout = 1800;

 				OracleParameter parameter;

 				OracleDbType dbType = OracleDbType.Object;

 				foreach (string colName in colHeaders)

 				{

 					dbType = GetOracleDbType(columnData[colName]);

 					parameter = new OracleParameter(colName, dbType);

 					parameter.Direction = ParameterDirection.Input;

 					parameter.OracleDbTypeEx = dbType;

 					parameter.Value = columnData[colName];

 					command.Parameters.Add(parameter);

 				}

 				connection.Open();

 				OracleTransaction trans = connection.BeginTransaction();

 				try

 				{

 					command.Transaction = trans;

 					result = command.ExecuteNonQuery();

 					trans.Commit();

 				}

 				catch (Exception ex)

 				{

 					trans.Rollback();

 					throw ex;

 				}

 			}

 		}

 		finally

 		{

 			if (connection != null)

 			{

 				connection.Close();

 				connection.Dispose();

 			}

 			GC.Collect();

 			GC.WaitForFullGCComplete();

 		}

 	}

 	return result;

 }

 /// <summary>

 /// 根据数据类型获取OracleDbType

 /// </summary>

 /// <param name="value">数据</param>

 /// <returns>数据的Oracle类型</returns>

 private static OracleDbType GetOracleDbType(object value)

 {

 	OracleDbType dataType = OracleDbType.Object;

 	if (value is string[])

 	{

 		dataType = OracleDbType.Varchar2;

 	}

 	else if (value is DateTime[])

 	{

 		dataType = OracleDbType.TimeStamp;

 	}

 	else if (value is int[] || value is short[])

 	{

 		dataType = OracleDbType.Int32;

 	}

 	else if (value is long[])

 	{

 		dataType = OracleDbType.Int64;

 	}

 	else if (value is decimal[] || value is double[] || value is float[])

 	{

 		dataType = OracleDbType.Decimal;

 	}

 	else if (value is Guid[])

 	{

 		dataType = OracleDbType.Varchar2;

 	}

 	else if (value is bool[] || value is Boolean[])

 	{

 		dataType = OracleDbType.Byte;

 	}

 	else if (value is byte[])

 	{

 		dataType = OracleDbType.Blob;

 	}

 	else if (value is char[])

 	{

 		dataType = OracleDbType.Char;

 	}

 	return dataType;

 }

GetOracleDbType

 /// <summary>

 /// 批量插入数据

 /// 该方法需要禁用该表所有触发器，并且插入的数据如果为空，是不会采用默认值

 /// </summary>

 /// <param name="table">数据表</param>

 /// <param name="targetTableName">数据库目标表名</param>

 /// <returns></returns>

 public bool InsertBulkData(DataTable table, string targetTableName)

 {

 	bool result = false;

 	string connStr = GetConnectionString();

 	using (OracleConnection connection = new OracleConnection(connStr))

 	{

 		using (OracleBulkCopy bulkCopy = new OracleBulkCopy(connStr, OracleBulkCopyOptions.Default))

 		{

 			if (table != null && table.Rows.Count > 0)

 			{

 				bulkCopy.DestinationTableName = targetTableName;

 				for (int i = 0; i < table.Columns.Count; i++)

 				{

 					string col = table.Columns[i].ColumnName;

 					bulkCopy.ColumnMappings.Add(col, col);

 				}

 				connection.Open();

 				bulkCopy.WriteToServer(table);

 				result = true;

 			}

 			bulkCopy.Close();

 			bulkCopy.Dispose();

 		}

 	}

 	return result;

 }

ALTER TABLE table_name DISABLE ALL TRIGGERS