C#连接oracle

1.引用Oracle.DataAccess.dll，安装oracle库，目录为D:\app\Administrator\product\11.2.0\dbhome_1\ODP.NET\bin\2.x

2. string oracleConnectionStr = "Data Source=(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=127.0.0.1)(PORT=1521))

(CONNECT_DATA=(SERVICE_NAME=OYD)));Persist Security Info=True;User ID=OYD;Password=123456;";

HOST为ip地址；PORT端口为1521；SERVICE_NAME为oracle用户；User ID为账号；Password为密码

获取oracle中监听对应的SERVICE_NAME，找到该目录D:\app\Administrator\product\11.2.0\dbhome_1\NETWORK\ADMIN中tnsnames.ora文件，

3. string beforeSql = "select * from \"sync_info\" where \"synced\"=0"; //利用转义符 \” ，添加” 标识关键字

DataTable beforeDt = OracleHelper.Fill(oracleConnectionStr, CommandType.Text, beforeSql, null)

 

to_char(sysdate,'yyyyMMdd') //oracle获取当前时间，并转换为yyyyMMdd格式

修改表名：alter table 旧表名 rename to 新表名;