C# 连接oracle 先执行truncate在执行insert

在C#中，连接Oracle数据库并先执行TRUNCATE再执行INSERT操作，通常需要借助Oracle的ADO.NET提供程序，如ODP.NET (Oracle Data Provider for .NET)。以下是一个简单的示例：

using OracleConnection; // 引入所需的Oracle连接库
using OracleCommand;

// 创建Oracle数据库连接
string connectionString = "Data Source=(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=<your_host>)(PORT=<your_port>))(CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=<your_service_name>));User Id=<your_user>;Password=<your_password>";
OracleConnection connection = new OracleConnection(connectionString);

try
{
    // 打开连接
    connection.Open();

    // 创建SQL命令
    string truncateTableSql = "TRUNCATE TABLE <your_table_name>";
    OracleCommand truncateCmd = new OracleCommand(truncateTableSql, connection);
    truncateCmd.ExecuteNonQuery(); // 执行TRUNCATE

    string insertSql = "INSERT INTO <your_table_name>(<column1>, <column2>) VALUES (:val1, :val2)";
    OracleCommand insertCmd = new OracleCommand(insertSql, connection);
    insertCmd.Parameters.Add(":val1", OracleDbType.Varchar2).Value = "<value1>";
    insertCmd.Parameters.Add(":val2", OracleDbType.Varchar2).Value = "<value2>";
    insertCmd.ExecuteNonQuery(); // 执行INSERT

    Console.WriteLine("Truncate and Insert operations completed successfully.");
}
catch (Exception ex)
{
    Console.WriteLine($"Error occurred: {ex.Message}");
}
finally
{
    // 关闭连接
    connection.Close();
}

请将上述代码中的`<your_host>`、`<your_port>`、`<your_service_name>`、`<your_user>`、`<your_password>`、`<your_table_name>`、`<column1>` 和 `<column2>`替换为实际的数据库信息。