C# Example:
using System;
using System.Data;
using System.Data.OracleClient;
public class Test
{
public static void Main(string[] args)
{
string connectionString =
"Data Source=testdb;" +
"User ID=scott;" +
"Password=tiger;";
IDbConnection dbcon;
dbcon = new OracleConnection(connectionString);
IDbCommand dbcmd = dbcon.CreateCommand();
string sql =
"insert into scott.emp " +
"(empno, ename, job, sal, deptno) " +
"values(123," +
"'Don Smith'," +
"'Cook'," +
"23021," +
"20)";
dbcmd.ConnectionString = sql;
dbcmd.ExecuteNonQuery();
dbcmd.Dispose();
dbcmd = null;
dbcon.Close();
dbcon = null;
}
}