dbForge Studio for Oracle是一个功能强大的集成开发环境(IDE),它提供了通用的数据编辑工具来管理数据库内和外部数据,能够帮助Oracle开发者提高PL/SQL的编码速度。这个工具可以同步不同Oracle服务器的数据并能够在开发过程中对管理程序进行自动化调整。此外,它还拥有大量与Microsoft Visual Studio一致,用于管理图形用户界面的光滑特性集。
dbForge Studio for Oracle (formerly known as OraDeveloper Studio) is a powerful Oracle database development tool. With dbForge Studio for Oracle, you can browse and edit database objects, run SQL statements and SQL scripts, debug PL/SQL statements, edit and export table data, and synchronize databases. You can also build visual representation of your schemas, create data reports. dbForge Studio for Oracle is focused on enhancing productivity and simplifying your daily database development tasks.
功能描述
需要培训、定制、外包?
请联系我们!企业QQ:800018081
慧都专业技术团队帮助您提高效率,节省成本,降低风险!
* 关于本产品的分类与介绍仅供参考,精准产品资料以官网介绍为准,如需购买请先行测试。
PL/SQL编码助手自动代码实现
代码片段
快速展现模式对象的信息
使用文档大纲进行导航
SQL代码的智能格式化数据库项目
数据库项目可以极大地帮助你促进数据库开发:创建一个空数据库项目或者导入的数据库项目。
管理项目中的SQL脚本和查询文件
部署整个项目或者是必需的更改到服务器数据库变更管理
当修改Oracle数据库结构,在服务器之间传输数据,分析数据库之间的差异,你可以:比较和同步数据和模式
定期进行数据库同步任务
生成比较报告项目管理器
在数据库搜索器中数据库的对象的结构就像是一棵树。编辑任何对象,你可以从这个窗口调用相应的可视化编辑器。你可以:在一个窗口管理多个表格。
在对象编辑器里使用撤销选项。
在一个单独的编辑器中可以浏览模式对象。Oracle PL/SQL调试器
PL/SQL调试器为按部就班的执行存储项目单元和SQL脚本而服务。你可以在观察窗口使用断点、评估并修改变量,也可以在调用堆栈窗口分析当前你的PL/SQL项目所调用的活动堆栈。查询分析器
使用查询分析器改进测试查询。工具可以帮助你发现问题并通过GUI. Profiler优化SQL查询:提供了可视化查询分析
比较分析结果模式导入/导出
导出完整的模式结构或使用模式导入/导出向导选定模式对象,复制数据库对象。使用这些向导,你可以从以下几点受益:Oracle的导入和导出实用程序向导。
导出项目的模式。
导出zip压缩文件。
支持命令行工具。数据库的实施
Oracle数据库实施和管理服务工具用于:管理用户权限
管理服务器会话
监控事件数据库设计器
使用可以创建、分析、逆向工程、打印和自定义Oracle数据库的数据库关系图可以用来:查看外键关系
显示数据库对象的属性
执行存储过程导入/导出数据
导入和导出用于填充数据库的Oracle数据。dbForge Studio可以导出11种常见格式并支持8种导入格式。数据的导出/导入过程是可定制的,并且可以通过命令行界面自动完成。报告与分析
数据的分析和报告在数据报告、数据透视表和主从关系视图的帮助下执行。全面的向导和工具可以以图表和表格的形式显示数据,并为提供用于调整数据布局、分组、排序等的方法。
dbForge Studio for Oracle comes in three editions:
Express gives you the basic FREE Oracle database tool
Standard works fine for everyday Oracle development tasks
Professional includes extra tools to advance your Oracle development to a new level
Key Features
dbForge Studio for Oracle includes a set of highly-customizable tools for performing any database-related task:
PL/SQL Editor
Type SQL code faster with dbForge Studio for Oracle. Together with the code completion,syntax highlighting, code folding features our Oracle development tool offers code snippets andcode navigation that will let you write and check SQL code effectively.
----------------------------------------------------------------------------------------------------------------------------
Data Editor
Data in Data Editor is displayed in a grid, where you can group, sort, display it in card view, copyit to clipboard, apply filtering, search for the data you need, edit foreign keys with a built-in editor. Data Editor supplied with our Oracle database tool lets you view and edit data with comfort.
----------------------------------------------------------------------------------------------------------------------------
Database Explorer
Database Explorer available in our Oracle development tool will help you view detailed object properties and browse data using Object Viewer, perform multi-selection for batch operations on objects, manage all connections as easy as ABC.
----------------------------------------------------------------------------------------------------------------------------
Integrated PL/SQL Debugger
PL/SQL Debugger provides such features as Step In, Step Over, Step Out, Breakpoints, Call Stackwith navigation, Watches, etc. With PL/SQL Debugger available in our tool for Oracle database management, you can debug any PL/SQL code and scripts easily and effectively.
----------------------------------------------------------------------------------------------------------------------------
Data Export/Import
dbForge Studio for Oracle database tool provides possibility to export data to and import it from the most popular formats (MS Access, Text, XML, MS Excel, etc.). Export and import can be tuned to meet all requirements. You can also automate data export and import using command line.
----------------------------------------------------------------------------------------------------------------------------
Database Diagrams
Visual representation of such database objects as tables, views, procedures, functions will be of great help when designing new databases or working with the existing ones. Just drag the objects - and you will be able to view and edit their properties, relations between them, etc.
----------------------------------------------------------------------------------------------------------------------------
Oracle Schema Compare Tool
Oracle schema compare tool provides highly customizable schema comparison andsynchronization. Process automation using command line, generation of comparison reports and schema synchronization script, and many other features will be here for you if you choose to use our Oracle database development tool.
----------------------------------------------------------------------------------------------------------------------------
Oracle Data Compare Tool
Try the Oracle data compare tool available in dbForge Studio to compare and synchronize data in your tables. Set different options, map your tables the way you want them to be mapped, generate comparison reports in different formats and automate data comparison using command line interface.
----------------------------------------------------------------------------------------------------------------------------
Database Projects
Project management system facilitates database development as it allows creating database projects and integrating related database development files. When building a project, you can create a single ready-to-deploy script for deploying database to the server.
----------------------------------------------------------------------------------------------------------------------------
Query Builder
Draw your queries with Query Builder. The Oracle development tool we offer allows creating queries without typing any code: drag'n'drop the tables/views you need, specify the columns you want to retrieve data from, joins, where, group by, etc clauses and execute your query.
----------------------------------------------------------------------------------------------------------------------------
Reporting and Analysis Tools
Design any data reports with parameters, customizable formatting, calculated summaries with the help of the dbForge Studio reporting tool. Streamline your work with multi-dimensional data, visualize data trends and dependencies with special charts, convert your data in pivot tables.
----------------------------------------------------------------------------------------------------------------------------
Schema Export/Import
Schema export/import wizards will let you preparedumps of your schemas and import them. You can select any of five compression levels to compress files, use auto delete of old dumps to free disc space, and use rich options set for a schema to export.
----------------------------------------------------------------------------------------------------------------------------
Schema Object Editors
Schema object editors provide clear and comprehensive environment for managing existing schema objects and creating new ones. For each schema object, there is a separate object editor, where you can set or modify any properties available for this object.
----------------------------------------------------------------------------------------------------------------------------
Administration Tools
Every Oracle developer will take advantage of possessing tools for manipulating user accounts,managing server sessions, etc., that can be used via graphical UI. With such Oracle development tool as dbForge Studio you will spare a lot of effort when performing database administration tasks.
----------------------------------------------------------------------------------------------------------------------------
Query Profiler
View explain plan and session statistics in Query Profiler to monitor query performance. Possibility to compare profiling results is the key in Oracle queries optimizations, as you can see differences in profiling results for query executions before and after modifications highlighted in the grid.
----------------------------------------------------------------------------------------------------------------------------
Find Database Objects
The Find Database Object functionality available in the dbForge Studio for Oracle development tool can effectively search databases and find a required database object by any fragment of its CREATE statement, as well as find a data fragment in one or several tables.