Oracle Instant Client是一款轻量级的数据库连接工具，用于在Windows操作系统上与Oracle数据库进行通信。在标题中提到的"Instantclient-basic-windows.x64-11.2.0.4.0.zip"是一个特定版本的Oracle Instant Client的压缩包，适用于64位的Windows系统。该版本号"11.2.0.4.0"表明这是Oracle Database 11g Release 2的一个更新。 在描述中提到了"装了PLSQL后需要装这个"，PLSQL Developer是一款流行的Oracle数据库管理和开发工具，它允许用户编写、测试和调试PL/SQL代码。有时，在安装PLSQL Developer后，可能会遇到无法正常连接到Oracle数据库的问题，尤其是在没有提供特定客户端组件的情况下。Oracle Instant Client包含了必要的库和组件，如oci.dll，这些是PLSQL Developer等应用程序与Oracle服务器通信所必需的。安装这个压缩包后，可以解决因缺少这些组件而导致的登录问题，例如无法看到通常的连接选择框。 Oracle Instant Client包含以下关键组件： 1. **oci.dll**: Oracle Call Interface (OCI) 是Oracle数据库的编程接口，使得开发者能够用C或C++编写应用来访问数据库。 2. **sqlplus**: 这是一个命令行工具，用于执行SQL查询和PL/SQL块，是数据库管理员和开发者常用的工具。 3. **tnsnames.ora**: 这个文件定义了数据库连接的服务名（Service Name），使得客户端能通过简单的服务名而非复杂的网络地址来连接数据库。 4. **ldap.ora**: 如果使用Oracle目录服务，此文件配置LDAP连接信息。 5. **network/admin** 目录：包含了其他网络配置文件，如listener.ora和sqlnet.ora，它们管理数据库监听器和网络通信设置。 安装Oracle Instant Client时，你需要将解压后的文件夹路径添加到系统的PATH环境变量中，以便PLSQL Developer等应用程序能找到所需的库文件。确保所有必要的依赖项都已安装，例如VC++ Redistributable，因为某些版本的Oracle Instant Client可能依赖于这些运行时库。 在标签中提到了"PLSQL"，这是Oracle数据库的结构化查询语言扩展，用于处理数据库对象、编写存储过程和触发器。PLSQL与SQL紧密集成，提供了一个强大的编程环境，可以处理复杂的业务逻辑。 Oracle Instant Client是连接Oracle数据库的重要组件，尤其对于使用PLSQL Developer或其他第三方工具的开发者和DBA来说，它是解决问题的关键。通过正确安装和配置，你可以顺利地进行数据库的连接、查询和管理工作。

PLSQL Developer 11.0.0.1762 中文绿色注册版(免Oracle11g客户端) 免安装Oracle客户端，绿色无公害。 说明： 1、点击 "启动PLSQL.exe" 即可免装oracle使用PLSQL 或者 使用qidong.bat启动 ； 2、instantclient_11_2为oracle 11 绿色精简版； 3、设置TNS,用记事本打开配置 ：instantclient_11_2\tnsnames.ora qidong.bat内容： set oracle_home=%~dp0\instantclient_11_2 set TNS_ADMIN=%~dp0\instantclient_11_2 set nls_lang=SIMPLIFIED CHINESE_CHINA.ZHS16GBK set LANG=zh_CN.GBK start PLSQLDev.exe 作用：设置临时变量，启动plsql

1：chinese.exe 为汉化包程序 2：plsqldev注册：将aalf.bat直接拷贝到安装目录PLSQL Developer下即可。假设安装目录是：D:\ProgramFiles\PLSQL Develop

64位版本的 PLSQL 正式版，只能运行在64位系统中，需要你安装 64 位的 Oracle 客户端。 安装请查看说明。 APRIL 17, 2020 - VERSION 14.0 RELEASED Built-in Version Control support for Git and Subversion For these file control operations PL/SQL Developer relies on a 3rd party shell extension that must be installed on your system. In the screenshots above “GIT Extensions” has been used. Worksets A workset is a set of Program Windows, SQL Windows, Test Windows, Command Windows, Report Windows and Diagram Windows that you are working on. Internal difference viewer The new viewer allows you to ignore differences in case and white space as usual, but it can also ignore differences in comments. Program Window enhancements The Program Window now highlights transaction statements, so that you can visually recognize the code that affects a transaction. As soon as you place the cursor on a transaction statement, all related statements within a program unit will be highlighted Debugger enhancements A variable name and value can now be copied to the clipboard through the new “Copy variable” popup menu item. Editor enhancements A function key “Editor: Refresh Code Assistant” has been added, to bring the Code Assistant up to date after creating new database objects. When selecting a word, all matching words will be highlighted. Marked editor text is automatically copied to the search field of the Find function. SQL Window enhancements You can now display multiple result sets simultaneously and can compare them: CLOBs and BLOBs are now fetched on demand to improve query performance. Single record view will now show column comments if available. The EXCEL and CSV export filenames can now include substitution variable values. The EXCEL and CSV export filenames can now include %time%, %hh%, %mi% and %ss% variables. For the “Export Results as SQL file” function you can now customize the initialization and finalization. The WITH_PLSQL hint is now supported. Command Window enhancements New EXPORT TABLES and EXPORT OBJECTS commands have been added. This allows you to automate frequent export jobs. You can easily build the command-line from the interactive export tools. The BEAUTIFY command now supports wildcards. The CONNECT command now shows the database list after typing @. The WITH_PLSQL hint is now supported. Object Browser enhancements The Object Browser will now show all overloaded versions of functions and procedures. You can now filter on multiple comma-separated object names (e.g. “dept%, emp%”). You can now refresh materialized views from the popup menu. File Browser enhancements Git and Subversion support has been added. File icons now indicate the PL/SQL Developer file type. You can now filter files based on the name, size, date, read-only status, and version control status. You can specify the filter in the options dialog You also can enter the filter expression directly at the top of the File Browser All windows shell functions are now available from the popup menu. You can now create a specific PL/SQL Developer file type from the “Create File” popup menu item. You can now add multiple files to a project at once. Project enhancements Git and Subversion support has been added. File icons now indicate the PL/SQL Developer file type. Table Definition Editor enhancements The Index and Partition storage can now be edited, copied, and pasted directly in the grid. Support for Row Archival has been added. Test Manager enhancements You can now add multiple Test Script files at once. You can now drag & drop Test Script files from the File Browser. You can now enable or disable multiple items at once. Connection List enhancements Window icons now indicate the PL/SQL Developer window type. Connection status icon moved to the left for consistency. Session Window enhancements You can now define Session Actions that can be performed from the popup menu of the session list: Session Actions can display feedback by writing dbms_output. Other enhancements Function keys have been added for “Search Bar” functions (Focus, Search, Go to next, Go to previous). Substitution variable checkbox and list values can now refer to other variable values as &variable. An “Unregister License” function has been added. Fixes Fixes for multiple monitors with different display scaling (file selector, print dialogs, MDI window title bars, scrollbar width) Conditional sections could be displayed incorrectly in the Code Contents Define Connections and Select Connection tree was incorrect on a secondary display with different DPI settings Menu items with icons from templates were too small on high dpi monitors Ribbon / Menu customization form options were not preserved Editors with a right margin and wrapping enabled did not wrap at the right margin View Stack Dump function now places the error lines in center of the editor Connection matches did not process proxy user expressions (user1[user2]@database) correctly for the application background DBMS_Jobs could not be edited

使plsql 中的日常操作更加便捷，可以自定义快捷键

这个版本是我用过最好用的版本 无需安装 解压直接运行plsqldev.exe 即可

《Oracle SQL 高级编程》随书附带的脚本集合

PLSQL Developer注册码Version 13版本亲测可用,按照对应粘贴产品代号、序列号、密码即可注册成功

PL/SQL Developer 12 注册机 注册码

精通 Oracle10g PlSQL 编程 精通 Oracle10g PlSQL 编程