Features

Features

• How to use SQL*Plus in Oracle

  In this section, learn how to use SQL*Plus in Oracle, which may be used to run SQL statement and scripts if an Oracle database does not have SQL Developer installed.  Continue Reading

• How to use SQL Developer to work with an Oracle database

  In this chapter, learn how to use Oracle SQL Developer to review or modify your database design, navigate database objects and create, export and import database connections.  Continue Reading

• Understanding SQL string functions

  Each week, SearchOracle.com will bring you tips and examples of one SQL string function, such as CHAR, CONCAT and REPLACE, in this chapter excerpt from the book Oracle CRM On Demand Reporting.  Continue Reading

• The top advice from Oracle experts in 2008

  This year the SearchOracle.com experts answered questions on Oracle errors, backups, jobs and more. Here's a look back at our most popular expert questions and answers of 2008.  Continue Reading

• New Web 2.0 tools: Beyond the basics

  Read about how to use advanced web 2.0 tools, including mashups and application-centric wikis, in Web 2.0 for the enterprise.  Continue Reading

• 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