Oracle

Comunidade & Grupos de Usu�rios Oracle

PL/SQL - Oracle SQL Procedural Language

Oracle em Linux

Oracle Database Enterprise est� dispon�vel para Oracle Enterprise Linux, Red Hat Enterprise Linux (RHEL) e Novell SuSE Linux Enterprise Server (SLES). Oracle Database 10g Express Edition (XE) em Linux x86 est� dispon�vel para as distribui��es Debian, Mandriva, Novell (SuSE), Red Hat e Ubuntu.

Utilit�rios Oracle

  • SQLTools for Oracle
    SQLTools � uma ferramenta leve e robusta para desenvolvimento PL/SQL em banco de dados Oracle. Inclui um editor de texto de programa��o, console SQL f�cil e poderosa e alguns utilit�rios SQL. Funciona com Oracle 7.3/8/8i/9i/10g. SQLTools � software livre, distribu�do sob licen�a GNU General Public License (GPL).
    SQLTools em 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 9.2.0.1 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 ( TOADSoft.com), 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) cont�m todos os scripts SQL que a maioria de n�s j� possui em seu arsenal. O "tchan" � a forma em que essa informa��o � apresentada. Todas as estat�sticas s�o geradas em tags HTML - que podem ent�o ser visualizadas em um navegador web. Cada relat�rio tem o c�digo fonte usado para a gera��o e notas com informa��o relevante sobre as estat�sticas coletadas. OraSnap atualmente tem mais de 110 scripts que geram uma multitude de informa��o sobre bancos de dados v7.3 e superior.
    OraHoo: PHP port do 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 (gratuito/comercial)
    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.


Certifica��o

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


Livros & Publica��es sobre Oracle

Livros sobre Certifica��o Oracle