1、运行plsqldev1102.exe
2、点击I Agree
3、点击NEXT
4、安装汉化
5、运行chinese.exe
6、
二、 然后进入PLSQL的主界面(登陆时直接点取消按钮也是可以进入主界面的)
,点击工具>>首选项,在如下界面做如下配置(instantclient在解压缩后文件中,位置是pl sql\instantclient_11_2)
Oracle主目录名,即为你的instantclient的解压路径。
经过如此配置后,我的PLSQL就能正常使用了,
三、修改instantclient_11_2/NETWORK/ADMIN/tnsnames.ora文件
# tnsnames.ora Network Configuration File: e:\app\Administrator\product\11.2.0\dbhome_1\network\admin\tnsnames.ora
# Generated by Oracle configuration tools.
ZZSN =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.50)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = zzsn)
)
)
ORCLCOLLECT =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 120.27.32.121)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = orcl)
)
)
ORCL =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 118.190.174.96)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = orcl)
)
)
Ip为所连数据库的iP, ZZSN、ORCLCOLLECT、ORCL是数据库名字
Oracle中较长number型数值的科学计数显示问题
number型数值的科学计数显示需要进行如下配置
在pl/sqldeveloper中->tools->preferences->sqlwindows->number fields tochar,选中该选项即可。
如果是汉化版,操作如下:在pl/sqldeveloper中->工具->首选项->SQL窗口->数字字段tochar,选中该选项即可。
数字即可正常显示