C#: Oracle

 

using System;
using System.Data;
//using System.Data.OracleClient;
using Oracle.DataAccess.Client;

// コンパイル方法
//   csc /r:C:\oracle\product\10.1.0\Db_2\BIN\Oracle.DataAccess.dll oracle.cs
//

public class OracleTest
{
 public static void Main()
 {
 string connectionString = "User Id=HR;Password=****;Data Source=HR.ORCL";
 Console.WriteLine(connectionString);
 OracleConnection conn = new OracleConnection(connectionString);
 OracleCommand command1 = new OracleCommand("SELECT * FROM HR.TABLE1", conn);
 conn.Open();
 OracleDataReader reader1 = command1.ExecuteReader();

 while (reader1.Read())
 {
 Console.WriteLine(reader1.GetString(0));
 }

 conn.Close();
 Console.WriteLine("Closed.");
 }
}