Tutorials

Tutorials

• Diving deeper into the SQL database features

  There are dozens of SQL database features for Oracle, IBM and Microsoft that have advantages and disadvantages that must be sorted through. This guide should help.  Continue Reading

• Guide to Oracle virtualization licensing and support

  In this guide, learn about Oracle virtualization licensing and support policies and how Oracle licensing and support for virtualization stacks up against its competition.  Continue Reading

• Oracle virtualization introduction guide

  This introductory guide to Oracle virtualization is designed to help you define and understand the basics of Oracle virtualization including Oracle's VM.  Continue Reading

• Guide to Oracle's virtualization strategy

  This guide to Oracle virtualization strategy covers how Oracle VM fits into the virtualization market, and Oracle's recent acquisition of Virtual Iron.  Continue Reading

• Oracle VM vs. VMware: A closer look

  Trying to decide between Oracle VM and VMWare for your Oracle virtualization needs? Read this Oracle VM vs. VMWare guide for a side-by-side comparison of the two Oracle virtualization vendors.  Continue Reading

• Oracle applications learning guide

  This learning guide is a one-stop shop for information on Oracle's changing role in the enterprise applications space, with news, analysis and tips on Oracle's acquisitions, Project Fusion, E-Business Suite and other apps, the battle between Oracle ...  Continue Reading

• Stored procedures in PL/SQL

  Learn about Oracle PL/SQL stored procedures, such as the stored procedure definition and stored procedure examples in this PL/SQL tutorial for beginners and experts.  Continue Reading

• PL/SQL functions and triggers in Oracle

  Learn about using Oracle PL/SQL functions and triggers, such as how to import a trigger and how and when to use a PL/SQL function in this PL/SQL tutorial.  Continue Reading

• PL/SQL datatypes in Oracle

  Learn about PL/SQL datatypes in Oracle, and learn the definitions of BLOB, CLOB, DATE, VACHAR2 and more in this PL/SQL tutorial for beginners and experts.  Continue Reading

• Choosing the right server hardware is all about choosing the right software

  Before evaluating the server hardware, knowing what edition of Oracle 11g to choose and whether to run that edition on a virtualized server is crucial. This section takes a look at factors to consider in making that decision.  Continue Reading

• Can Sun shine running Oracle 11g?

  Until the recent past, not many users would consider using a Sun server to run a departmental database. With the Oracle-Sun merger, that could change. Here are some Sun contenders worthy of consideration.  Continue Reading

• The best of the Oracle 11g-ready servers

  With all the software upgrade choices made, it is time to look at the server hardware. This section is a deep dive comparing the technical merits of five servers deemed capable of running Oracle 11g database with good performance.  Continue Reading

• Comparing servers for Oracle database 11g upgrades

  An Oracle 11g upgrade means server hardware will need more octane. Find out how to compare Oracle 11g servers for database upgrades and which servers will speed performance.  Continue Reading

• Oracle database upgrades: the in-place vs. migration upgrade decision

  With a full understanding of Oracle 11g's capabilities and how you plan to exploit them, it is time to plan the upgrade. But do you carry out an in-place upgrade or a migration upgrade? This section examines the pros and cons of each  Continue Reading

• Oracle data export guide

  Exporting data is a common task for an Oracle DBA, but not necessarily a straightforward one. In this compliation of questions and answers, SearchOracle.com's resident Oracle experts Eli Leiba, Karen Morton and Brian Peasland explain how it's done, ...  Continue Reading