代理商丨PL/SQL Developer强大的PL/SQL编辑器

oracle百（千）万级表数据导出工具，用于Oracle数据库导出大数据量表 ，保存格式如csv

目录 1.介绍 2.安装 2.1系统需求 2.2工作站安装 2.3基于服务器安装 2.4脚本安装 2.5卸载PL/SQL DEVELOPER 3编写程序 3.1创建程序 3.2保存程序 3.3修改程序 3.4编译程序 3.5置换变量 4测试程序 4.1创建测试脚本 4.2运行测试脚本 4.3变量类型 4.4保存测试脚本 4.5跟踪运行时间错误 4.6包声明和JAVA会话声明 4.7查看结果 4.8查看DBMS_OUTPUT 4.9查看HTP输出 4.10调试 4.11跟踪运行 4.12回归测试 5优化 5.1使用解释计划窗口 5.2自动统计 5.3PL/SQL概览图 5.4SQL跟踪 6专用SQL 6.1使用SQL窗口 6.2结果表格处理 6.3实例模式查询 6.4连接查询 6.5置换变量 6.6更新数据库 6.7查看和编辑XMLTYPE 6.8直接查询导出 6.9保存SQL脚本 6.10创建标准查询 7命令窗口 7.1输入SQL语句和命令 7.2开发命令文件 7.3支持命令 8创建与修改非PL/SQL对象（因篇幅限制下面2级目录省略） 9图标 10报告 11图形 12工程 13任务项目 14窗口、数据库会话和事务 15浏览对象 16首选项 17工具 18编辑器 19大数据编辑器 20查询设计器 21PL/SQL美化器 22模板 23窗口对象 24可停放和浮动的工具 25授权 26ORACLE文件系统 27帮助系统 28定制

PLSQL工具，操作Oracle的SQL编辑工具。方便对数据库的增删改查。图形化操作界面。有利于对Oracle数据库的操作和学习。是个不错的SQL操作工具。

32位版本的 PLSQL 正式版， 安装中文包时请注意安装路径是否为PLSQL程序的路径。 备注：新版本Ribbon启用了 Ribbon 界面，改动较大，不习惯的建议不要更新。 部分插件会加载失败。 keygen生成注册码非100%有效~~请多尝试几次 New features Ribbon User Interface PL/SQL Developer now uses a new Ribbon User Interface instead of a Menu User Interface: The Quick Access Toolbar above the ribbon contains the most frequently used functions, so that they are always immediately available. You can customize the Quick Access Toolbar to your own liking. Users that prefer a menu-like system to preserve screen real estate can select to automatically hide the ribbon. In the preferences you can select an option to revert to the familiar toolbar layout from PL/SQL Developer 11.0 and earlier. Single Document Interface On the "View" ribbon you can now choose between a Single Document Interface (SDI) or Multiple Document Interface (MDI - the same as in PL/SQL Developer 11.0 and earlier). In SDI mode you always see just one maximized window. A tab control above the window allows you to quickly switch between the windows: General User Interface Enhancements PL/SQL Developer is now fully compliant with High-DPI screens such as 4K monitors and notebooks. All controls and images will scale with resolution (some Plug-Ins may still need to be enhanced). Click on the image below to enlarge this example of a 15" 4K notebook (250% DPI): All window types now have a specific icon color, so that you can quickly identify the type in the Window List, in the SDI tab control, in the window titles, and so on. The transaction status is now visible in the status bar of a window, next to the "Saved" and "Executing" indicators. Added user interface preference "Preselect current user for object selection lists". PL/SQL Clipboard The new PL/SQL Clipboard is a dockable tool that stores the history of all SQL and PL/SQL code you copy to the Windows clipboard, so that you can paste the clipboard item again in the future. It has a filter function so that you can quickly find a clipboard item based on its contents: At the bottom you see the PL/SQL Clipboard history items. Clicking on an item will show the text with syntax highlighting in the preview pane, and will show the timestamp above the preview pane. Double-click on an item to paste the text in the cursor location of the current editor or drag & drop it to a specific location in an editor. You can use the editor preferences to configure when and how items are added to and deleted from the PL/SQL Clipboard. Debugger Enhancements You can now display compound variable values such as user-defined types, records and cursors: Support has been added for Error Breakpoints, which allow you to break execution when a specific exception (handled or unhandled) occurs: Breakpoints can now be saved and loaded. Debug object privileges can now be granted and revoked from the user interface. Code Assistant Enhancements The Code Assistant can now include column names from a DML statement context without using an alias: The Code Assistant can now describe sub-records. The Code Assistant now includes an <All> choice for default object type constructors. The Code Assistant can now include synonyms for user object lists. The Code Assistant no longer pre-selects <All> after typing part of a parameter/column name. SQL Window Enhancements A new preference has been added: "Null value cell color for mandatory columns". This allows you to quickly identify mandatory columns when adding new records: The result set selection can now be copied as an expression list: "column in (value, value, ...)" by right-clicking on a selection and selecting "Copy as expression list" from the popup menu. This allows you to quickly build a where clause based on the selection: When viewing or editing LOB's the contents for common data formats will automatically be recognized, so that an external viewer or editor can be invoked: Changes made and saved in an external editor will automatically be propagated to the column data. The SQL Window will now navigate to the offending cell in the result set after an insert or update with a column-specific error. The rowid column is now omitted when exporting a result set grid in SQL format. Test Window Enhancements You can now define Standard Tests for a specific function or procedure: A Standard Test can be invoked from the popup menu when right-clicking on the function or procedure in the Object Browser or in a PL/SQL source: The Test Window now supports Oracle12c implicit results, which are automatically detected and added to the variable list: A new Oracle / Output preference has been added to save dbms_output to a file. The filename can include