Free download sql plus pc app Files at Software Informer. Nowadays, when IT is flourishing more and more...
sql developer是oracle的一款图形化界面的产品,不过也不是太好用,还是用第三方工具pl/sql吧
Download SQL Developer Extension for VSCode Download SQL Developer SQL Developer application interfaces The World's #1 Tool for Managing your Oracle Database, Oracle SQL Developer provides users with three interfaces: Desktop, Browser, and Command Line. ...
首先确定下自己电脑上装的Oracle11g的具体版本: C:\Users\clg>sqlplus / as sysdba SQL*Plus: Release 11.2.0.1.0 Production on 星期二 3月 22 10:40:19 2016 Copyright (c) 1982, 2010, Oracle. All rights reserved. 连接到: Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Produ...
经了解后得知,错误原因:ORA-12526: TNS: 监听程序: 所有适用例程都处于受限模式。 解决办法:使用系统管理员身份运行以下一段代码 ALTER SYSTEM DISABLE RESTRICTED SESSION; 经过更改后,错误消失,能够成功连接Oracle SQL Developer
Oracle 11gR2数据库:https://www.oracle.com/technetwork/database/enterprise-edition/downloads/112010-win64soft-094461.html PL/SQL developer(含注册机):https://pan.baidu.com/s/1kUfY8GB密码: 1ky8 首先打开PL/SQL,会发现没有database可以选择,我们可以以非登录方式登陆PL/SQL(直接点cancel即可)。
安装plsql developer后,启动时取消登陆,进入界面,在tools->Preferences中,设置两个输入框: Oracle Home:C:\instantclient_11_2OCI Library:C:\instantclient_11_2\oci.dll 如果直接将tnsnames.ora文件放在C:\instantclient_11_2下,需配置环境变量:TNS_ADMIN=C:\instantclient_11_2; ...
使用pl sql developer的版本7以上,下载CnPlugin插件,文件解压缩后,将里面的CnPlugin.dll和CnPlugin文件夹放到你的pl sql的安装路径中的PlugIns文件夹的下面 此链接有CnPlugin插件的安装包: https://download.csdn.net/download...
To develop and execute SQL scripts you can use PL/SQL Developer's Command Window. This window has the same look and feel as SQL*Plus, and additionally has a built-in script editor with corresponding syntax highlighting. Now you can develop your scripts without the "edit script / save it ...
http://www.oracle.com/technetwork/developer-tools/sql-developer/downloads/index.html 需要注册一个oracle otn.../otn/java/sqldeveloper/sqldeveloper-17.2.0.188.1159-x64...