Introduction to eight major Oracle development tools

Session leader and Apps Associates founder, CEO Sridhar Bogelli is based on mass application development advisor, warns Oracle developers should properly use the tools provided by Oracle and Third-party vendors to help them and their companies avoid some production-related problems. These tools include:

First, Sql*plus

Sql*plus is the interface of SQL command line and Pl/sql language and the reporting tool for connecting Oracle database clients and servers. Sql*plus can be used interchangeably and run through scripts. According to Oracle, the previous version of Sql*plus is called the UFI (user-friendly interface). The UFI is included in Oracle first to fourth versions. "Sql*plus will always be there," Bogelli said. has been used as an editor from Oracle databases (distributions) to the present. This is the first version of the UNIX environment, which was a version of Windows 10 years ago. ”

Second, Toad for Oracle Software

Quest Software's very popular Oracle software Toad is the SQL editor, which is popular with free software and commercial editions, but where free software is licensed, there are also places that are banned.

The company's use of 5 users is 60 days, and according to the Quest website, the commercial version of the Toad price ranges from 870 to 4900 dollars per seat.

"Nine years later, Toad really changed things, and it has improved a lot over the past two years," Bogelli told the conference's developers. I want to say that if someone is using sql*plus, they should all switch to toad. ”

Three, SQL Developer

Oracle published SQL Developer in March, formerly known as Project Raptor. It is free to download software that allows database developers to run SQL statements and SQL scripts, edit and debug Pl/sql code, view and update data, and guide object browsing and creating documents.

SQL Developer includes a series of reports and parts such as code format programs and code snippets. Oracle companies say these can help Oracle developers quickly set passwords.

One of the database administrators (DBAs) Floyd absher when SQL developer and Toad are openly opposed to Oracle, Project Raptor Beta tester Progressive Medical The company consistently searchoracle.com that the full version of Toad is much more powerful than the SQL Deverloper. But he added that some of the deficiencies of SQL developer could be filled with other Oracle applications, such as Oracle applications discovered by Enterprise Manager.

Iv. Workflow Builder

According to Oracle, Workflow Builder 11i is a business process management system that supports business process definition, business process automation, and business process integration. The company says workflow involves e-business kits to be able to model, automate, and continually improve business processes based on custom business practices.

Bogell said: "Through workflow builder you can make full use of a series of functions to carry out a huge project." You can also divide the program into smaller pieces and treat each small program as a business process. This tool works well and is also good at creating features.

Five, XML Publisher

According to Oracle, XML Publisher is a java-based product that belongs to Oracle Fusion middleware. It leverages 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 transforms these documents into XSL-FO standard formats.

Bogelli said: "I think Oracle is pushing this tool, it has some good features." This tool is a stand-alone product, but if you subscribe to the E-business Kit this tool is free because it is licensed with the E-business suite. ”