完整的開發(fā)環(huán)境集成

• IDE中提供的所有數(shù)據(jù)庫開發(fā)和管理任務(wù)

• SQL編輯器，數(shù)據(jù)庫對象編輯器和其他編輯器的行為與通常的IDE文檔類似

• 幫助集成到Microsoft Visual Studio .NET和Borland Delphi中

組件設(shè)計人員的擴展功能  （適用于OraDirect .NET專業(yè)版）

• 用于訪問有用功能的新動詞

• SQL編輯器，查詢生成器，所有對象編輯器，以方便工作

方便的服務(wù)器瀏覽

• 多個同時連接

• 快速調(diào)用對象編輯器

• 單擊訪問對象屬性

• 完整對象搜索

• 動態(tài)數(shù)據(jù)查看

• 數(shù)據(jù)庫對象依賴支持

• 瀏覽記錄

簡單的數(shù)據(jù)庫對象操作

• 方便易用的可視化編輯器，適用于所有對象

• 視覺設(shè)計和文本模式

• 用于數(shù)據(jù)庫對象的可生成DDL腳本

• 復制數(shù)據(jù)庫對象

• 在應(yīng)用更改之前，將對緩存進行緩存

• 對表，視圖，物化視圖，表和視圖列的注釋支持

• 撤消選項

數(shù)據(jù)庫項目支持

• Project Explorer工作區(qū)，用于將相關(guān)數(shù)據(jù)庫對象和腳本組織到單個項目中

• 易于項目部署

• 工作區(qū)節(jié)省

• 方便的文件控制

• 項目PL / SQL程序編譯

• 能夠?qū)⒄麄€項目導出到文件中

• 能夠?qū)㈨椖繉С龅絊QL * Plus腳本中

增強的SQL編輯器

• 語法突出顯示

• 上下文相關(guān)的代碼完成和參數(shù)信息

• 鼠標懸停數(shù)據(jù)庫對象的快速信息

• 與可導航文檔大綱面板集成的代碼大綱

• 廣泛的SQL代碼模板集合

• 在完整歷史記錄中存儲所有已執(zhí)行的查詢

• 快速SQL歷史記錄導航

• 在SQL文件導航欄上顯示已創(chuàng)建的數(shù)據(jù)庫對象和子對象

• 代碼書簽支持

PL / SQL和腳本調(diào)試

• 調(diào)試存儲過程和函數(shù)，對象類型，包，觸發(fā)器和SQL腳本

• 步入，跳過，運行游標和斷點支持

• 支持評估和修改變量

• 可導航的調(diào)用

高級數(shù)據(jù)庫管理工具

• 安全管理器，用于操縱用戶，角色，用戶配置文件和權(quán)限

• 會話管理器用于控制會話

• 事件監(jiān)視器，用于監(jiān)視和發(fā)送Oracle警報和管道消息

Visual Query Builder

• 強大的交互式查詢結(jié)構(gòu)

• 無需鍵入一行代碼來撰寫查詢

• 可視化創(chuàng)建所有類型的JOIN

• 高級選項卡式編輯器，支持完整的SELECT語句子句

• 與Database Explorer集成

擴展的SQL執(zhí)行功能

• 支持以下SQL * Plus命令：@，@@，ACCEPT，CLEAR，CONNECT，DEFINE，DESCRIBE，EXECUTE，PROMPT，REMARK，VARIABLE

• 執(zhí)行文件，存儲過程和函數(shù)以及選定的代碼片段

• 使用Plan工具分析查詢性能

• 腳本支持

• 異步執(zhí)行

強大的基于網(wǎng)格的數(shù)據(jù)編輯器

• 高度可定制

• 就地過濾，排序和分組

• Paginal mode

• 單獨的LOB編輯器，用于查看和更新簡單的二進制對象和長文本

• 數(shù)據(jù)操作控制的事務(wù)機制

• 客戶端緩存

• 數(shù)據(jù)打印

• 圖形卡視圖

輕松數(shù)據(jù)導出

• 支持文本，HTML，XML和MS Excel文件格式

• 可自定義的導出文檔外觀屬性

• 導出整個網(wǎng)格或選定的行和列

數(shù)據(jù)庫導出/導入

• 基于本機Oracle Exp和Imp實用程序

• 友好的用戶界面

• 不同的出口模式

• 高級數(shù)據(jù)庫導入功能

可自定義的架構(gòu)導出/導入到SQL或從SQL導入

• 提取任何支持的架構(gòu)對象

• 從選定或所有表中提取數(shù)據(jù)

• 不同的提取選項

• 高級架構(gòu)導入功能

每個支持的架構(gòu)對象的用戶友好的對象編輯器

• 表

• 視圖

• 參數(shù)

• Unique key

• 外鍵

• 檢查約束

• Package

• 存儲過程

• 存儲功能

• 觸發(fā)

• 用戶類型

• 序列

• 物化視圖

• 物化視圖日志

• 代名詞

• 簇

• 數(shù)據(jù)庫鏈接

• XML模式

靈活的連接

• 支持從7.3到11g的所有Oracle版本

• 能夠在單個應(yīng)用程序中使用多個Oracle Homes

• Instant Client支持

• 可選的直接訪問模式，用于在沒有Oracle客戶端軟件的情況

方便靈活的用戶界面

• 標簽文件

• 具有不同視圖的文件

• 文檔選項卡組

• 高度可定制的布局

• 可自動隱藏和浮動的可停靠工具窗口

• 可定制的工具欄

綜合幫助系統(tǒng)

• 每個窗口和選項卡的上下文幫助

• 每個OraDeveloper組件的詳細參考

• 幫助快速入門的教程

Full development environment integration

• All database development and administration tasks available from your favorite IDE
• SQL Editor, database object editors and other editors behave like usual IDE documents
• Help integrated into Microsoft Visual Studio .NET and Borland Delphi

Component designers' extended capabilities
(for OraDirect .NET Professional Edition)

• New verbs to access useful features
• SQL Editor, Query Builder, all of Object Editors to facilitate your work

Convenient Server Browsing

• Multiple simultaneous connections
• Quick invocation of object editors
• Single-click access to object properties
• Full object search
• Dynamic data viewing
• Database object dependency support
• Browsing history

Easy Database Object Manipulation

• Convenient and easily accessible visual editors for all objects
• Visual design and text modes
• Generatable DDL scripts for database objects
• Duplication of database objects
• Changes are cached until you apply them
• Comment support for tables, views, materialized views, table and view columns
• Undo option

Database Project Support

• Project Explorer workspace for organizing related database objects and scripts into a single project
• Easy project deployment
• Workspace saving
• Convenient document control
• Project PL/SQL programs compilation
• Ability to export an entire project into a file
• Ability to export a project into an SQL*Plus script

Enhanced SQL Editor

• Syntax highlighting
• Context-sensitive code completion and parameter information
• Mouseover quick info for database objects
• Code outlining integrated with navigatable Document Outline panel
• Extensive collection of SQL code templates
• Storage of all executed queries in full history log
• Quick SQL history navigation
• Display of created database objects and subobjects on SQL file Navigation bar
• Code Bookmark support

PL/SQL and Script Debugging

• Debugging of stored procedures and functions, object types, packages, triggers, and SQL scripts
• Step into, step over, run to cursor and breakpoint support
• Support for evaluating and modifying variables
• Navigatable Call Stack

Advanced Database Administration Tools

• Security Manager for manipulating users, roles, user profiles and privileges
• Session Manager for controlling sessions
• Event Monitor for watching and sending Oracle alerts and pipe messages

Visual Query Builder

• Powerful interactive query construction
• No need to type a line of code to compose a query
• Visual creation of all types of JOINs
• Advanced tabbed editor with full SELECT statement clause support
• Integration with Database Explorer

Extended SQL Execution Features

• Support of the following SQL*Plus commands: @, @@, ACCEPT, CLEAR, CONNECT, DEFINE, DESCRIBE, EXECUTE, PROMPT, REMARK, VARIABLE
• Execution of files, stored procedures and functions, and selected code fragments
• Analysis of query performance with the Plan tool
• Script support
• Asynchronous execution

Powerful Grid-Based Data Editor

• Highly customizable
• In-place filtering, sorting, and grouping
• Paginal mode
• Separate LOB Editor for viewing and updating simple binary objects and long text
• Transaction mechanism for data manipulation control
• Client-side caching
• Data printing
• Graphic card view

Easy Data Export

• Support of Text, HTML, XML, and MS Excel file formats
• Customizable export document appearance attributes
• Export of entire grid or selected rows and columns

Database Export/Import

• Based on native Oracle Exp and Imp utilities
• Friendly user interface
• Different export modes
• Advanced database import features

Customizable Schema Export/Import to/from SQL

• Extracting of any supported schema object
• Data extracting from selected or all tables
• Different extracting options
• Advanced schema import features

User-friendly Object Editor for Every Supported Schema Object

• Table
• View
• Index
• Unique key
• Foreign key
• Check constraint
• Package
• Stored procedure
• Stored function
• Trigger
• User type
• Sequence
• Materialized view
• Materialized view log
• Synonym
• Cluster
• Database link
• XML schema

Flexible Connectivity

• Support for all Oracle versions from 7.3 to 11g
• Ability to use several Oracle Homes in single application
• Instant Client support
• Optional direct access mode for establishing connections without Oracle client software

Convenient and flexible user interface

• Tabbed documents
• Documents with different views
• Documents tab groups
• Highly customizable layout
• Dockable tool windows with auto hide and floating
• Customizable toolbars

Comprehensive help system

• Context help for every window and tab
• Detailed reference for every OraDeveloper component
• Tutorials that help you get started quickly