Database Articles

  Home arrow Database Articles arrow Using the SQL Reference Manual
DATABASE ARTICLES

Using the SQL Reference Manual
By: Murach Publishing
  • Search For More Articles!
  • Disclaimer
  • Author Terms
  • Rating: 5 stars5 stars5 stars5 stars5 stars / 2
    2011-06-29

    Table of Contents:
  • Using the SQL Reference Manual
  • Perspective

  •  
     

    SEARCH CODEWALKERS

    Using the SQL Reference Manual


    (Page 1 of 2 )

    In this conclusion to a seven-part series on using Oracle SQL Developer and other tools, you'll learn how to use the SQL Reference manual, and more. This article is excerpted from chapter two of the book Murach's Oracle SQL and PL/SQL, written by Joel Murach (Murach; ISBN: 1890774502).

    How to use the SQL Reference manual

    Figure 2-13 shows how to use another useful tool for working with the Oracle Database: the SQL Reference manual. This manual is available as a searchable PDF file that contains detailed technical information about the SQL statements that work with Oracle Database. You can use this PDF file to quickly look up a wide variety of information about the Oracle Database including information about its SQL statements and functions.

    How to view the manual

    If you have the PDF file for the SQL Reference manual installed on your computer as described in appendix A, you can open the manual by using the Windows Explorer to double-click on the PDF file. This will open the PDF file in the Adobe Reader. Of course, this assumes that you have the Adobe Reader installed on your system. If you don’t, you can download it for free from Adobe’s web site.

    How to look up information

    Once you’ve opened the PDF file for the SQL Reference manual in the Adobe Reader, there are several ways that you can look up information. In short, you can use any standard techniques for working with a PDF file to work with this manual. If you need help, you can use the Adobe Reader’s Help menu to learn more about using Adobe Reader.

    One easy way to look up information is to scroll through the table of contents. To do that, click on the plus (+) and minus (-) signs in the left column to expand or collapse the topics. Then, when you find the topic you want, click on it to display the topic in the right pane. Once you do that, you can scroll up or down to view the entire topic. In this figure, for example, I expanded the topic named “SQL Statements: SAVEPOINT to UPDATE,” and I clicked on the SELECT topic to display information about the SQL SELECT statement.

    Another easy to way to look up information is to search for a specific word or phrase. To do that, type the word or phrase in the Find text box and press the Enter key. Then, you can click on the Find Next or Find Previous button to find the next or previous occurrence of the word or phrase. In this figure, for example, I entered “select statement” into the Find text box and pressed the Enter key.

    How to use the Oracle Database SQL Reference manual

    Description

    1. The Oracle Database SQL Reference manual is available as a searchable PDF file that contains detailed technical information about the SQL statements that work with the Oracle Database.
    2. If you have the PDF file for the SQL Reference manual installed on your computer, you can start it by using the Windows Explorer to double-click on the file.
    3. To scroll through the table of contents, click on the plus (+) and minus (-) signs to expand or collapse the topics. When you find the topic you want, click on it to display the topic in the right pane. Then, you can scroll up or down to view the entire topic.
    4. To search for a particular word or phrase, type the word or phrase in the Find text box in the toolbar and press the Enter key. Then, you can click on the Find Next or Find Previous button to find the next or previous occurrence of the word or phrase.

    NOTE 

    • The name of the Oracle Database SQL Reference manual varies slightly from one release to another.

    --------------------------------------------Figure 2-13 How to use the Oracle Database SQL Reference manual

    More Database Articles Articles
    More By Murach Publishing

    blog comments powered by Disqus

    DATABASE ARTICLES ARTICLES

    - MariaDB, a MySQL Alternative, Opens Foundati...
    - Oracle Supporting HP Itanium Again, Finally
    - Completing a Book Inventory Management System
    - Uploading Images for a Book Inventory Manage...
    - Finishing the Add Book Story for a Book Inve...
    - Integration Testing for a Book Inventory Man...
    - User Stories for a Book Inventory Management...
    - Unit Testing a Book Inventory Management Sys...
    - Testing a Book Inventory Management System
    - Implementing Models for a Book Inventory Man...
    - Book Inventory Application: Publishers and B...
    - Handling Publishers in a Book Inventory Mana...
    - Publisher Administration for Book Inventory ...
    - Book Inventory Management
    - Using the SQL Reference Manual

    Developer Shed Affiliates

     



    © 2003-2017 by Developer Shed. All rights reserved. DS Cluster - Follow our Sitemap