|
Solution Search:
|
Oracle Tips
How to uninstall Oracle
Part of our "How do I do that in Oracle?" series, this tip explains in detail how to uninstall Oracle software (8i, 9i or 10g) from your system. This tip is compiled largely of advice from our expert Oracle DBAs including installation expert Maria Anderson and...
More...
Jul 12, 2007
Mike Ault's Oracle "good practices": Oracle coding
It would take a book to completely delineate all SQL and PL/SQL (let alone Oracle-related 3GLs) good practices -- indeed several have been written. However, in this section I will try to list a few of the "heavy-hitters."
It is a good practice in PL/SQL to use array processing (for example, bulk collect and forall... More... Feb 23, 2007
Recovering from user errors
This is an excerpt from Chapter 29 of Oracle Database 10g OCP Certification All-In-One Exam Guide by Damir Bersinic and John Watson, copyright 2006 from Oracle Press, a division of McGraw-Hill. Click here to read the full chapter.
In this chapter you will learn how to... More... Oct 30, 2006
A bit wiser with Oracle technology
of the primary key in the data source reference table and bitwise logical operations within the Oracle database to denormalize the one-to-many relationship between a customer and its data sources. She could store this value in one column for each row.
Binary numbers Binary numbers (base two) are most commonly represented as... More... Oct 30, 2006
DBA Articles
Third-party tools for Oracle: Special report
Listen to the full-length podcast to learn more about the Toad for Oracle release and how it works both as a developer and DBA tool.
This review of Toad for Oracle 10 examines how Toad can be used by both Oracle developers and DBAs ? a feature that... More... May 25, 2010
New Oracle Database 11g book offers 'underground' tips
April Sims, a DBA at Southern Utah University and an Oracle Certified Professional, published a book last month called ?Oracle... More... May 14, 2010
What is the required skill set for an Oracle RAC DBA?
How different is the required skill set for an Oracle DBA who is transitioning from traditional individual database servers to implementing and supporting an Oracle RAC... More... Apr 12, 2010
|