Features

Web 2.0 users, community and participation in the enterprise

In this chapter, learn Web 2.0 basics for the enterprise, including how to cater to your Web 2.0 users, foster a Web 2.0 community, encourage participation and more. Continue Reading
Tips for Web 2.0 success and setting Web 2.0 goals in the enterprise

Get tips for Web 2.0 success and setting Web 2.0 goals in the enterprise with this chapter from the book, "Reshaping Your Business with Web 2.0." Continue Reading
Enterprise Web 2.0 blogs, wikis and content management

Learn how Web 2.0 blogs, wikis and content management systems can help your business get started in enterprise Web 2.0. Continue Reading
Enterprise search and links for Web 2.0

In this chapter, read about enterprise search and links for Web 2.0 and how to use this approach in your business. Continue Reading
Writing single-row and multiple-row subqueries

This chapter excerpt explains how to use and write single-row and multiple-row subqueries in SQL, with sample code and exercises. Continue Reading

List the types of SQL subqueries

In this chapter, learn about the three broad divisions of a subquery in SQL: Single-row, multiple-row and correlated subqueries. Continue Reading
Using subqueries in SQL

In this chapter, read examples and sample code for the types of problems that SQL subqueries can solve, including star transformation, generating a table from which to SELECT, generating rows to be passed to a DML statement and more. Continue Reading
Define SQL subqueries

This chapter of "OCA Oracle Database 11g: SQL Fundamentals I Exam Guide" explains how a subquery, a query that is nested inside a SELECT, INSERT, UPDATE, or DELETE statement or inside another subquery, is defined and used in SQL. Continue Reading
SearchOracle.com blogs

A landing page for our blogs, including Eye on Oracle with news, commentary, analysis and anecdotes, and Ear on Oracle, SearchOracle.com's podcast blog. Continue Reading
Oracle Fusion Update Center

Everything you need to know about Oracle's high-profile acquisition spree and Fusion integration plans is here in one spot. Continue Reading
Oracle vs. SAP: Round two

We recently asked two prominent experts to argue their respective cases for SAP vs. Oracle. These follow-up columns are their official rebuttals to each other's arguments. Continue Reading

Technical college or university?

ITKnowledge Exchange member "neoCentric" had a question about the differences between technical schools and universities. Fellow techies jumped in on the conversation. Here is a portion of the conversation. Continue Reading
Oracle 10g datafile I/O statistics

The Oracle10g database significantly improves the I/O subsystem, but it is still important to constantly monitor the I/O workload on the database. This excerpt, taken from the book "Oracle Tuning Power Scripts: With 100+ High Performance SQL Scripts... Continue Reading
Inside Oracle10g dynamic sampling

Oracle9i introduced the new dynamic sampling method for gathering run-time schema statistics, and it is now enabled by default in Oracle10g. But you may want to turn it off to remove unnecessary overhead in some circumstances. This excerpt, taken ... Continue Reading
SQL Tuning with SQL Access Advisor

This excerpt, taken from "Easy Oracle Automation: Oracle10g Automatic Storage, Memory and Diagnostic Features" by Dr. Arun Kumar R, describes the process of using SQL Access Advisor for tuning SQL. Continue Reading