Features

Features

• How to view and edit table column definitions

  In this chapter, learn how to edit and view column names and column definitions for a table, and when to use SQL Developer to do so.  Continue Reading

• How to work with the Oracle database home page

  In this chapter, learn how to work with an Oracle database, including how to start and stop the Oracle database and use the database homepage, before learning how to use Oracle SQL Developer.  Continue Reading

• 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