Fyracle
Developer Kit
Documentation

Fyracle
Syntax
Guide

Fyracle Developer Kit Documentation

The 0.8.x and 0.9.x releases will come with a gradually expanding set of documentation. The documentation set included in the Developer Install Kit for release 0.8.3 consists of:

• Quick Start Guide
• Fyracle Syntax Guide
• O'Reilly SQL pocket guide
• O'Reilly PL/SQL pocket guide
• Java Programmers Guide

This set of documentation will be made more Fyracle specific with the next releases of Fyracle. We are pleased that O'Reilly and its PL/SQL authors are supporting Fyracle by making their work available and we recommend that you buy their books:

• Jonathan Gennick
• Bill Pribyl
• Stephen Feuerstein (have you tried his QNXO yet?)
• Chip Dawes

O'Reilly SQL pocket guide

This unique reference can be a major help to programmers who use SQL in their day-to-day work. Not just an endless collection of syntax diagrams, this small guide addresses the language's complexity head on and leads by example. This pocket guide presents the most crucial information about SQL in a compact and easily accessible format, covering the four commonly used SQL variants--Oracle, IBM DB2, Microsoft SQL Server, and MySQL. Topics include:

• Data manipulation statements (SELECT, DELETE, INSERT, UPDATE, MERGE) and transaction control statements (START TRANSACTION, SAVEPOINT, COMMIT, ROLLBACK).
• Common SQL functions (date, numeric, math, trigonometric, string, conversion, aggregate)
• Such topics as literals, NULLs, CASE expressions, datatype conversion, regular expressions, grouping and summarizing data, joining tables, and writing queries (hierarchical, recursive, union, flashback) and subqueries.

Instead of presenting complex and confusing syntax diagrams, the book teaches by example, showing the SQL statements and options that readers are most like to use. All example data is available on the O'Reilly web site.

O'Reilly PL/SQL pocket guide

When you need a reminder or quick answer to a PL/SQL problem Oracle PL/SQL Language Pocket Reference, 3rd Edition is the key. Updated for Oracle10g, it includes fundamental language elements; statements for program control, cursor management, and exception handling; the basics of records, procedures, functions, triggers, and packages; and the calling of PL/QL functions in SQL, and much more.

The 3rd edition of this popular mini-reference boils down the most vital information from Oracle PL/SQL Programming into a handy guide to PL/SQL basics. The book includes fundamental language elements, such as block structure, identifiers, variables, datatypes, ad declarations; statements for program control, cursor management, and exception handling; the basics of records, procedures, functions, triggers, and packages; and the calling of PL/QL functions in SQL.

And there's more. This concise guide also covers Oracle objects, collections, external procedures, Java integration, and new elements like regular expressions, compile-time warnings, more implicit conversion, FORALL support for non-consecutive indexes, and more. The amount of valuable information packed into this slim volume--intelligently arranged for quick accessibility--make this an indispensable reference for new and seasoned Oracle database developers alike.