- 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.
|
- 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 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.
|
- Oracle9i: Auto-Tuning Using the Server Parameter File
- May 1, 2002
- Megh Thakkar discusses how to use the server parameter file (SPFILE) in Oracle9i for auto-tuning of your Oracle instances.
|
- Overcoming High-Latency Database Access with Java Stored Procedures
- May 13, 2004
- Java Stored Procedures: a way to put slow Java code in your otherwise fast database or a quick solution for certain database performance problems? They can be both, as it turns out. Tim Stevens takes a look at a situation in which the adoption of Java Stored Procedures quickly and effectively solved some serious performance issues in a database-driven system, all without a complete rewrite of existing database code.
|
- Planning an Oracle Database
- Nov 16, 2001
- This sample chapter from Oracle DBA on Linux and Unix covers basic physical database design. Good database design will ensure fast performance, simplified management, and protection from data loss.
|
- 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.
|
- Property Classes in Oracle Developer
- Nov 30, 2001
- Programming with Oracle Developer author Matthew Bennett gives an example of using property classes in Oracle Developer.
|
- 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.
|
- Sales Tracking Application Web Site -- Buy a Car
- Feb 9, 2001
- Build a web site using PL/SQL and Java.
|
- SQL in PL/SQL
- Mar 4, 2015
- In this chapter from Oracle PL/SQL by Example, 5th Edition, learn how to make use of variables and the various ways to populate variables. This chapter also covers transactional control in PL/SQL by explaining what it means to commit data as well as how SAVEPOINTs are used.
|
- SQL Server Kicks Oracle's Butt
- Mar 25, 2005
- Oracle enthusiasts love to bash SQL Server, and Buck Woody thinks it's high time that the debate is taken to a professional form. If it's to be an argument, he wants to involve the discipline of logic to see which is better: SQL Server or Oracle. Care to see who wins?
|
- 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.
|
- 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!
|
- 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 Beauty of TOAD for Oracle
- Jan 6, 2010
- Linda Leung caught up with TOAD experts Bert Scalzo and Dan Hotka to discuss TOAD, how it's used, and their views on where Oracle as a company is headed.
|
- To Partition or Not to Partition -- Partitioning Features in Oracle 8i
- Feb 9, 2001
- Learn what partitioning is and the useful features of partitioning in the Oracle implementation.
|
- Toad for Oracle Unleashed: Working with SQL
- Aug 3, 2015
- This chapter from Toad for Oracle Unleashed covers various aspects of the SQL Editor window, such as various modes to compile and execute code, using Toad history for past SQL, enhancing the interface to best fit your needs, using little-known items within the SQL Editor, code templates, and building SQL without typing.
|
- TOAD Setup and Configuration
- Sep 18, 2009
- Bert Scalzo and Dan Hotka review some of the more common and critical setup and configuration steps necessary to fully maximize your initial TOAD experience.
|
- 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.
|