- Relationships Should NOT Be Natural!
- Apr 30, 2004
- Using naturally occurring data can have negative impact on database performance. We should restrict ourselves to using cold, hard, sequential numbers, and forget about those warm, comfortable relationships with data that are so familiar.
|
- Dynamic Reconfiguration and Oracle 9i Dynamically Resizeable SGA
- Apr 9, 2004
- This article explains how Oracle 9i can operate in combination with Sun's dynamic reconfiguration (DR).
|
- Fundamentals of Programming in PL/SQL
- Feb 6, 2004
- In Oracle PL/SQL by Example, Third Edition, authors Benjamin Rosenzweig and Elena Silvestrova cover Oracle 10G and all the fundamentals. In this sample chapter, you'll be introduced to the key words and their syntax. You'll also expand on simple block structure with an exploration of scope and nesting blocks.
|
- Tuning ORACLE to Minimize Recovery Time: For Solaris Operating System on SPARC
- Feb 6, 2004
- This article provides recommendations for tuning ORACLE on SPARC processor-based systems running the Solaris Operating System to minimize recovery in the event of a system or database failure.
|
- An Oracle Programmatic and General Reference
- Dec 19, 2003
- Need to look up the Oracle operators, functions, format models, reserved words, and privileges? This handy set of charts, from the Oracle DBA SQL Quick Reference, will help you find what you need.
|
- Basic Concepts for Guerrilla Oracle
- Jul 4, 2003
- Get the important foundational information you need to fully understand and successfully build your Guerrilla Oracle database. You will explore five important topics, including databases, the Oracle Server environment, SQL programming languages, development tools, and the Web.
|
- Programming Language Fundamentals in PL/SQL
- Jul 4, 2003
- In learning any language, it is necessary to first learn the key words, what they mean, and how to use them. It is the same when you are learning the PL/SQL language. Discover the different types of key words and then their full sytax to bring you to programming excellence.
|
- Oracle Web Application Programming for PL/SQL Developers: Remote Server Access
- Jun 20, 2003
- Get the basics of remote server access as well as how you can benefit from this access today. You will experience workable examples that will bring you to an immediate and practical understanding of remote server access.
|
- Java, Databases, and Oracle
- Apr 25, 2003
- If you're a Java enthusiast but haven't fallen for a database system yet, discover why Java and Oracle are a perfect match for your applications.
|
- TOAD SQL Editor
- Apr 18, 2003
- Learn how to use TOAD to create and execute SQL scripts, save the output, and examine the explain plan by looking at every option available in the SQL Editor.
|
- Introduction to Oracle Web Applications
- Apr 4, 2003
- Before baking a cake, you need to know the ingredients; the same is true for Web apps. First take a look at the basics of the Internet, the Web, and browsers and then see how PL/SQL can be a powerful component for Web applications.
|
- Oracle PL/SQL Programming Concepts
- Jan 24, 2003
- PL/SQL is Oracle's Procedural Language extension to SQL. It is commonly used to write data-centric programs to manipulate data in an Oracle database. Here's a basic primer to help beginners get started.
|
- art_gore_outsourcing
- Jan 1, 2003
|
- Oracle DBA: Backup and Recovery Scripts
- Dec 27, 2002
- Having the right backup and recovery procedures is crucial to the operation of any database. It is the responsibility of the database administrator to protect the database from system faults, crashes, and natural calamities resulting from a variety of circumstances. Learn how to choose the best backup and recovery mechanism for your Oracle system.
|
- Sun StorEdge Instant Image 3.0 and Oracle8i Database Best Practices
- Sep 20, 2002
- A methodology for implementing the Sun StorEdge Instant Image 3.0 Point-In-Time copy technology to perform non-intrusive and efficient backup operations on Oracle8i databases, without impacting business operations, is presented.
|
- Oracle vs. SQL Server, Part 5 - Dissecting Oracle 9i
- Aug 30, 2002
- See the pure power of this awarding-winning RDBMS by looking at the outstanding features and benefits that it has to offer you.
|
- Oracle vs. SQL Server, Part 4 - The Softer Side of SQL Server 2000
- Aug 9, 2002
- See the conclusion of Rob Hawthorne's review of the good, the bad, and the ugly in Microsoft's SQL Server 2000. And there's more on Oracle to come!
|
- Oracle vs. SQL Server, Part 3 - A Closer Look at SQL Server
- Aug 2, 2002
- Explore Microsoft's SQL Server 2000, looking at features and benefits of this relational database management system.
|
- The Battle of the RDBMSs: SQL Server 2000 Versus Oracle 9i (Part 2)
- Jun 28, 2002
Database expert Rob Hawthorne explores the beginnings of both Microsoft and the SQL Server database as part of his series comparing SQL Server with Oracle 9i.
|
- The Battle of the RDBMSs: SQL Server 2000 Versus Oracle 9i (Part 1)
- Jun 21, 2002
- Database expert Rob Hawthorne explores the Oracle Corporation and Oracle RDBMSs, peeping into the beginnings of both the company and the very popular Oracle database. See how the RDBMS sprang from the CIA!
|