Best Tools for Oracle Developers

TOAD for Oracle



TOAD Tool for Oracle Application Developers is a very popular tool. This tool Includes SQL Editor, Schema Browser, Procedure Editor, SQL Modeler. Quest Software product TOAD increases user productivity and improves application code quality. TOAD for Oracle available current version is v10.6.

SQL Insight



SQL Insight is a tool is used to speed, improve, and simplify application and database development.  SQL Insight editors support various file types, SQL, PL/SQL, Java, HTML, XML, C++, and Perl. Latest version is SQL Insight 3.

PL/SQL Developer


PL/SQL Developer is an Integrated Development Environment that is specifically targeted at the development of stored program units for Oracle Databases. Over time we have seen more and more business logic and application logic move into the Oracle Server, so that PL/SQL programming has become a significant part of the total development process. PL/SQL Developer focuses on ease of use, code quality and productivity, key advantages during Oracle application development. The latest version of PL/SQL Developer is 8.0.

KeepTool

KeepTool's tools are a suite of user-friendly, well-architected, resource-frugal components designed to fit your enterprise's Oracle-centric roles, be they modelers, architects, developers, DBAs or even data operators.  The current version is 9.1.2.5.

RapidSQL

RapidSQL supports multiple databases transparently, integrates with Source Code Control tools, helps you manage your projects, provides build management, produces wonderful reports on any database objects. The latest version of RapidSQL is 7.7.

DBHawk



DBHawk Oracle Tool (formerly DBAConnect) from DataSparc provides convenient administration of your Oracle database through any web browser. DBHawk is easy to install and straightforward to use on Windows, Linux, UNIX, MAC OS, HP-UX, AIX platform. DBHawk is supported with Oracle database versions 9, 10g, Express and 11g

DeZign



DeZign for Databases is an intuitive database design tool for developers and DBA's that can help you model, create and maintain databases. The software uses entity relationship diagrams (ERDs) to graphically design databases and automatically generates the most popular SQL and desktop databases.  DeZign supports Oracle, ANSI Level2, dBase, IBM DB2, Informix. The new version of DeZign is v6.

SQL Navigator



SQL Navigator is a powerful, lightweight tool built around an advanced PL/SQL editor with a GUI object browser giving users quick access to database objects and the ability to make PL/SQL editing and testing fast and effortless

Spotlight on Oracle E-Business Suite



This product is designed to help the administrators of Oracle E-Business Suite to meet the expectations of your users, and to chronize updates from development staff and from Oracle.


Comments

  1. sap upgrade toolsOctober 31, 2011 at 10:50 PM

    This post explains the tools which are mainly used for Oracle developers. In last post we have seen tools for Oracle database. I am really impressed with the work of this blog. Your effort is clearly visible. Some tools you must have used while others are new so learn them.

    ReplyDelete

Post a Comment

Popular posts from this blog

What is Oracle Integration Cloud Service - ICS?

Image
Oracle Integration Cloud Service (ICS) is a solution that enables you to simplify integrations between cloud applications, and between cloud and on premises applications. It helps you create connections to well-known and less-known SaaS and PaaS applications, using the available cloud adapters, publish or subscribe to the Messaging Cloud Service, or use industry standards such as SOAP, REST, FTP, File, and JMS. For more information watch this Oracle video.
Read more

How to Create Packages in Oracle Database using TOAD for Oracle

Image
What are Packages in Oracle Database A package is a group of procedures, functions, variables and SQL statements created as a single unit. It is used to store together related objects. A package has two parts, Package Specification and Package Body. Package Specification Package Specification acts as an interface to the package. Declaration of types, variables, constants, exceptions, cursors and subprograms is done in Package specifications. Package specification does not contain any code. Package Body Package body is used to provide implementation for the subprograms, queries for the cursors declared in the package specification.
Read more

How to create a Simple Scheduler Job in Oracle Database using Toad

Image
Scheduler is a process which runs programmed jobs at scheduled times. This process wakes up at the specified time and runs automatically. The basic elements of the scheduler are: Jobs Schedules Programs A job specifies what needs to be executed and when. A program is a collection of metadata that will be executed by the scheduler. It contains the name of the program (a procedure or an executable, the type of the program (pl/sql block, shell script etc). A schedule specifies when and how many times a job is executed. 1. Login to the database using Toad, and create a Scheduler Job as follows;
Read more