1,navicat 即可连接。
2,出现的问题。navicat连接oracle数据库失败:
Cannot load OCI DLL 87:
Instant Client package is required for Basic and TNS connection.
https://blog.csdn.net/wangjie919/article/details/79471559
所需的包,直接去orcale 官网下载即可。(instantclient-basic-windows.x64)百度
下载对应的64 位或者 32 位的。
插入语句
Oracle:
insert into TEST("name","age","enname","label1","label2","test") values('张三',66,'sd','sdf','sdf','sdf');