Eight powerful tools in Oracle development tools

The following describes common Oracle development tools to help beginners have doubts about development. If you have any good development tools, contact us. For your sharing.

I. SQL * Plus

SQL * Plus is the interface of SQL command line and PL/SQL language and a reporting tool for connecting Oracle database customers and servers. SQL * Plus can be used alternately and run through scripts. According to Oracle, the previous version of SQL * Plus is called the UFIUser-Friendly interface ). UFI is included in Oracle versions 1 to 4. Bogelli said: "SQL * Plus will always exist. From Oracle Database Release) has been used as an editor. This is the first version in the Unix environment, and the first version of Windows 10 years ago ."

Ii. Oracle software Toad

The Oracle Software Toad, which is very popular in Quest Software, is the SQL editor. It is popular with free Software and commercial versions, but free Software is licensed, some areas are also prohibited. The company uses less than five users for 60 days, and according to the Quest website, the commercial Toad price ranges from $870 to $4900/seat. Bogelli said to the participating developers: "Today, Toad has actually changed some things, and it has improved a lot in the past two years. I would like to say that if someone is using SQL * Plus, they should switch to Toad ."

Iii. SQL Developer

Oracle released SQL Developer in March, called Project Raptor. It allows database developers to run SQL statements and SQL scripts for free, edit and debug PL/SQL codes, view and update data, guide object browsing, and create documents. SQL Developer includes a series of reports and some components such as code formatting programs and code snippets. Oracle says these help Oracle developers quickly set passwords. When SQL Developer and Toad are exposed to the public because of Oracle, Project Raptor beta tester Floyd Absher, one of them is a database administrator DBA) similar to Progressive Medical Inc, it consistently told SearchOracle.com that Toad has more functions than SQL Deverloper. However, he added that some shortcomings of SQL Developer can be filled by other Oracle applications, such as Oracle Applications discovered by Enterprise Manager.

4. Workflow Builder

According to Oracle, Workflow Builder 11i is a business program management system that supports business program definition, business program automation, and business program integration. The company said Workflow involved E-Business Suite's ability to model, automatically control, and continuously improve Business processes based on custom Business practices.

V. XML Publisher

According to Oracle, XML Publisher is a Java-based product of Oracle Integrated middleware. It uses a range of desktop tools such as Adobe Acrobat and Microsoft Word to allow users to create their own report formats on XML data extracts. XML Publisher converts these documents into standard XSL-FO formats.

6. Discoverer

According to Oracle, Oracle Business Intelligence Discoverer10g is a query, report, analysis, and Web release tool. It allows users to access dedicated data stacks, data warehouses, online transaction processing systems, and E-Business suites.
The company said that Discoverer 10g provided new features in earlier versions, including a comprehensive report and analysis interface for relational data and multidimensional data OLAP. Bogelli said: "Discoverer is a query-only tool that can run on any Oracle database. Once you create a view layer, commercial users use it to select the desired object and write it to queries.

VII. JDeveloper

Oracle company said that Oracle JDeveloper 10g is a Java2 Enterprise Edition development environment, including support for development, debugging and configuration of E-Business applications and Web services. Jdeveloper includes a complete set of tools to help developers manage resources, model, debug code, test, profile, and configure.

Bogelli points out that Jdeveloper includes a small PL/SQL editor and a Business Process Extension Language (BPEL) Editor.

Developer 6i (9i and 10g) -- Forms and Reports

According to Oracle, Oracle Forms Develope is an environment used to establish a data center. Internet applications are based on PL/SQL, oracle Reports Developer is a reporting tool for users to access information through institutions. Both tools are part of the Oracle Developer Suite.

1. Code required to modify the Oracle Stored Procedure
2. Summary of Oracle stored procedures
3. Code for implementing the Oracle Stored Procedure
4. In-depth high-performance dynamic Oracle SQL Development
5. Analysis of Oracle SQL optimization rules