Oracle Comunnity & User Groups

PL/SQL - Oracle SQL Procedural Language

Oracle on Linux

Oracle Database Enterprise is available for Oracle Enterprise Linux, Red Hat Enterprise Linux (RHEL) and Novell SuSE Linux Enterprise Server (SLES). Oracle Database 10g Express Edition (XE) for Linux x86 is available for Debian, Mandriva, Novell (SuSE), Red Hat and Ubuntu distributions.

Oracle Tools

  • SQLTools for Oracle
    SQLTools is a light weighted and robust tool for Oracle PL/SQL database development. It includes a text editor, easy and powerful sql console and a couple of sql utilities. It works with Oracle 7.3/8/8i/9i/10g. SQLTools is free software, distributed under GNU General Public License (GPL).
    SQLTools at SourceForge.
  • Oracle SQL Developer
    Oracle SQL Developer is a new, free graphical tool for database development. With SQL Developer, you can browse database objects, run SQL statements and SQL scripts, and edit and debug PL/SQL statements. You can also run any number of provided reports, as well as create and save your own. SQL Developer enhances productivity and simplifies your database development tasks. SQL Developer can connect to any Oracle Database version and later and runs on Windows, Linux and Mac OSX.
  • TOAD - Tool for Oracle Application Developers
    Surgido como uma ferramenta gráfica Windows multi-uso (gratuita!) para desenvolvedores e DBAs Oracle (, este verdadeiro "canivete suíço" para Oracle foi adquirido pela Quest Software e hoje é pago. É uma ambiente cliente gráfico baseado em Windows para desenvolvimento e administração de recursos em bancos de dados Oracle. Completo, rápido e eficiente, o TOAD possui editor SQL, Editor de Procedimentos (PL/SQL) com formatador e depurador integrados, Navegador de Esquemas com todo tipo de informações e ferramentas associados a cada tipo de recurso ou objeto (na forma de abas e botões), mais o módulo Quest DBA, com recursos voltados aos DBAs, como comparação de esquemas, gerenciamento de espaço, import/export, controle de sessões e privilégios etc. Tudo-em-um.
  • SQL Navigator
    Oracle PL/SQL server-side development tool. By Quest Software.
  • YASQL - Yet Another SQL*Plus Replacement
    Software open source, interface de linha de comando para Oracle, alternativa ao SQL*Plus.
  • OraSnap
    Free Oracle Performance Utility. By Stewart McGlaughlin, Oracle DBA.
    OraSnap (Oracle Snapshot) contains all the SQL scripts that most of us already have in our arsenal. The "twist" is the way the information is presented. All of the statistics are generated with HTML tags - which can then be viewed with a web browser. Each report has the source code used for the information and notes with relevant information about the statistics gathered. OraSnap currently has over 110 scripts that generate a multitude of information for v7.3 and newer databases.
    OraHoo: PHP port of OraSnap, by V. Satheesh Babu.
  • SQL Detective (comercial)
    SQLDetective is a powerful and easy-to-use graphical user interface to Oracle databases. It provides an integrated environment for developing database objects, writing and debugging stored programs, executing and testing SQL and PL/SQL commands, as well as searching and modifying data and analyzing the dependencies between the objects.
  • DbVisualizer - The Universal Database Tool (free/commercial)
    Minq Software. Supports Oracle, SQL Server, DB2, MySQL, PostgreSQL, Informix IDS, JavaDB/Derby, Sybase ASE, Cache, HSQL and others.
  • TOra
    Toolkit for Oracle, open source multi-plataforma (Qt library), que visa ajudar o DBA ou desenvolvedor de aplicação de banco de dados. Inclui PL/SQL Debugger, editor SQL com destaque de sintaxe, navegador do BD, e um abrangente conjunto de ferramentas para DBA.
    TOra SourceForge Project.
  • DBAComp
    DBAComp(anion) is a free, open-source Oracle administration tool. It allows to visualise the content of the data dictionary of Oracle databases. It does this in a way that allows you to drill down from one item of information to related ones in a completely graphical way. It runs on every platform with Qt (2.1.0 or higher) and Oracle (8.0.5 or higher) support, including Linux, Solaris, Windows.
  • QA: Quick Access Form
    An Oracle Forms dynamic utility form, by Steve Cosner. QA provides instant access with just a few mouse clicks to any table in any Oracle database. It is available for anyone with access to any Oracle Forms version, from 6i through 10g. QA is an essential tool for developers to view and modify data in their tables while testing and debugging Forms and database packages and triggers during development. QA is also useful for casual users who need to view and modify data in tables where a specific user interface is not available. There is no fee or registration required to use QA.
  • Material Dreams - Oracle
    Useful Oracle tools products. Oracle Links.


OCA: Oracle Database 10g Administrator Certified Associate
1Z0-042Oracle Database 10g: Administration I
OCP: Oracle Database 10g Administrator Certified Professional
Requires: OCA 10g
1Z0-043Oracle Database 10g: Administration II
OCP Upgrade: DBA OCP 9i to 10g
Requires: OCP 9i
1Z0-040Oracle Database 10g: New Features for Administrators
OCP Bridged Upgrade: DBA OCP 8i to 10g
Requires: OCP 8i
1Z0-045Oracle Database 10g: New Features for Oracle8i OCPs
Oracle9i OCA: Oracle Certified Associate
1Z0-007Introduction to Oracle9i SQL
1Z0-031Oracle9i DBA Fundamentals I
Oracle9i OCP: Oracle Certified Professional
Requires: OCA 9i
1Z0-032Oracle9i DBA Fundamentals II
1Z0-033Oracle9i Performance Tuning
OCP Upgrade: DBA OCP 8i to 9i
Requires: OCP 8i
1Z0-030Oracle9i Database: New Features for Administrators
OCP Bridged Upgrade: DBA OCP 7.3 or 8 to 9i
Requires: OCP 7.3 or 8
1Z0-035Oracle9i DBA New Features for Oracle7.3 and 8 OCPs

Oracle Books & Publications

Books on Oracle Certification