h
PC Voyager

General

PC's

Internet

Developers

Webmasters

Education/Jobs

 

 

 

 

Designer

.

 
you are in    Home    DATABASES 
ORACLE
 
Oracle is an enterprise-grade RDBMS (relational database management system).  The organisation was formed in 1977 and targets high-end workstations and network computers. 
 
These relational database systems were the first to support SQL (structured query language), which is now an industry-standard. 

Add a link|Report dead link

SOFTWARE & TOOLS
 
Karma
An open-source tool for Oracle users.
Perl / Web, Sean Hull
.
Orac aka PerlDBAdmin
An open-source tool for Oracle users.
Perl / Tk, Andy Duncan
.
OraEdit PL/SQL editor
An open-source tool for Oracle users.
.
Oracle toolbox
An open-source tool for Oracle users.
PHP / Web
.
JRetriever
An open-source tool for Oracle users.
.
Oraclean
This script will clean up the log, trace and audit files in an Oracle installation. This software is also available as an installation package for GNU Debian Linux.
.
SQLExp
This tool will tell you the structure and properties of any given database object - it can show a table that's in the database, including all the constraints and indexes, grants and audits. But all other Oracle7/8/8i/9i objects can be shown as well.
.
DESCR Tool
Use 'descr' to get a description about an object. This shell script does the same as the SQL*Plus command DESCRIBE, but you don't have to start SQL*Plus to use it.
.
How tool
Use 'how' to let Oracle tell you how it will execute a given DML (SELECT, UPDATE, INSERT or DELETE) command. Basically it shows you the formatted output of the EXPLAIN PLAN command.
.
DBLists
Use 'dblsts' to get a complete listing of the use of a tablespace. It is used mainly to check for performance problems, but it also gives a good overview of how much space is in use.
.
DBRecovr
Assist with the recovery of any damaged database.
.
Orastart
This software will integrate Oracle 8.0/8i/9i with GNU Debian Linux. It automatically starts and stops the database(s) and listener(s) on system startup/shutdown.
.

Back to top...

RESOURCES
 
GO4DBA
This site is all about providing existing and aspiring DBAs with "the right stuff". Free downloadable exam sheets.
.
Oracle Resources
Dedicated to Oracle Jobs. Constantly changing database of jobs world-wide.
.
ORAsearch.com
Oracle job board for professionals with at least 1 years paid experience.
.
DBAsupport.com
Oracle resources, scripts. forums, faq, technical docs and more.
.
Oracle Databases
A collection of links from your About.com Guide to Databases for the best Oracle resources on the Net.
.
Search Database
One of the best database-specific information resources for enterprise IT professionals, covering database basics, languages, administration, Oracle, MS SQL and more.
.
DB Forums
A usenet group for Oracle tools, resources and discussions.
.
Oracle Tutorial
A good listing of various Oracle-related resources, including source code, jobs, training, user groups, faq, tips and more.
.

Back to top...

TRAINING & TUTORIALS
 
Free-Ed.net
Over 120 completely free online courses, tutorials, study guides and lessons in technical, vocational and academic topic areas.
Method: Online Type: Self-paced
.
Oracle Tutorial Online Oracle Training Courses
Oracle and Oracle 8 tutorial for home study.
Method: Online Type: Self-paced
.
OraFAQ
A good listing of various Oracle and SQL tutorials.
.
Oracle Power
A listing of over 70 tutorials and examples.
Method: Online Type: Self-paced
.
Oracle/SQL Tutorial
This Oracle/SQL tutorial provides a detailed introduction to the SQL query language and the Oracle Relational Database Management System.
Method: Online Type: Self-paced
.
Oracle 8 Certification Training
Interactive and self-paced computer training & certification videos and CD roms, for IT Professionals.
Method: CD Rom - Videos Type: Self-paced
.
SkillBuilders
Let us help you learn Oracle.  Free Oracle Tutorials and Free Oracle Training Lessons are available here.
Method: Online Type: Self-paced
.

Back to top...

.
.
© Copyright  and Service Mark of PC Voyager 1999 - 2003.  All rights reserved. | Terms of use | Privacy Policy .