www.openlinksw.com
docs.openlinksw.com

Book Home

Contents
Preface

Overview
Installation Guide
Quick Start & Tours
Sample ODBC & JDBC Applications
Conceptual Overview
Administration
Data Access Interfaces
Virtual Database Engine
SQL Reference
Datatypes
User Defined Types
XML Column Type
Identifier Case & Quoting
Wide Character Identifiers
Qualified Names
Literals, Brace Escapes
CREATE TABLE Statement
DROP TABLE Statement
CREATE INDEX Statement
DROP INDEX Statement
ALTER TABLE Statement
CREATE VIEW Statement
CREATE XML SCHEMA Statement
DROP XML SCHEMA Statement
Sequence Objects
INSERT Statement
UPDATE Statement
SELECT Statement
COMMIT WORK, ROLLBACK WORK Statement
CHECKPOINT, SHUTDOWN Statement
Stored Procedures as Views & Derived Tables
GRANT, REVOKE Statement
SET Statement
Anytime Queries
Best Effort Union
Standard and User-Defined Aggregate Functions
Virtuoso SQL Optimization
SQL Inverse Functions
SQL Grammar
Bitmap Indices
Transitivity in SQL
Fast Phrase Match Processor
Geometry Data Types and Spatial Index Support
SQL Bulk Load, ELT, File Tables and Zero Load Operations
Virtuoso Cluster Programming
SQL Procedure Language Guide
Database Event Hooks
Data Replication, Synchronization and Transformation Services
Web Application Development
XML Support
RDF Data Access and Data Management
Web Services
Runtime Hosting
Internet Services
Free Text Search
TPC C Benchmark Kit
Using Virtuoso with Tuxedo
Appendix
Virtuoso Functions Guide

Abstract

SQL Reference.

Table of Contents

9.1. Datatypes
9.1.1. Date Literals
9.1.2. Casting
9.1.3. Time & Date Manipulation
9.1.4. Declaring Collations of Expressions
9.2. User Defined Types
9.2.1. CREATE TYPE Statement
9.2.2. ALTER TYPE Statement
9.2.3. DROP TYPE Statement
9.2.4. CREATE METHOD Statement
9.2.5. Type Instances
9.2.6. Instance References
9.2.7. NEW Operator
9.2.8. Finding Methods - Method Signatures Generation & Comparison
9.2.9. Getting & Setting Member Values of Type Instances (member observers & mutators)
9.2.10. Calling Static Methods
9.2.11. Calling Instance Methods
9.2.12. Serializing & Deserializing Type Instances
9.2.13. User Defined Types Utility Functions
9.2.14. Hosted Foreign Objects in Virtuoso
9.2.15. Using User Defined Types to Represent SOAP Structures
9.2.16. Consuming Third-Party SOAP Services via User Defined Types
9.2.17. UDT Security
9.3. XML Column Type
9.4. Identifier Case & Quoting
9.5. Wide Character Identifiers
9.5.1. UTF-8 Implementation Notes For ODBC
9.5.2. UTF-8 Implementation Notes In JDBC
9.6. Qualified Names
9.6.1. Qualifiers and Owners
9.6.2. Default Qualifiers
9.6.3. USE Statement, USE identifier
9.7. Literals, Brace Escapes
9.7.1. Strings
9.7.2. Numbers
9.7.3. ODBC Brace Escapes
9.7.4. Hexadecimal Literals
9.7.5. Binary Literals
9.8. CREATE TABLE Statement
9.8.1. Syntax
9.8.2. NOT NULL
9.8.3. IDENTITY (Auto Increment)
9.8.4. DEFAULT
9.8.5. PRIMARY KEY Constraint
9.8.6. UNDER
9.8.7. FOREIGN KEY Constraint
9.8.8. The CHECK Constraint
9.8.9. The WITH SCHEMA Constraint
9.9. DROP TABLE Statement
9.10. CREATE INDEX Statement
9.11. DROP INDEX Statement
9.12. ALTER TABLE Statement
9.12.1. Adding a CHECK Constraint
9.13. CREATE VIEW Statement
9.14. CREATE XML SCHEMA Statement
9.15. DROP XML SCHEMA Statement
9.16. Sequence Objects
9.17. INSERT Statement
9.17.1. INSERT SOFT
9.17.2. INSERT REPLACING
9.18. UPDATE Statement
9.19. SELECT Statement
9.19.1. Syntax
9.19.2. Description
9.19.3. Column Aliasing - AS Declaration
9.19.4. Join examples
9.19.5. Ordering and Grouping
9.19.6. Derived Tables
9.19.7. Query Expressions
9.19.8. LIKE Predicate & Search Patterns
9.19.9. The TOP SELECT Option
9.19.10. CASE, NULLIF, COALESCE, CAST Value Expressions
9.19.11. SELECT BREAKUP
9.20. COMMIT WORK, ROLLBACK WORK Statement
9.21. CHECKPOINT, SHUTDOWN Statement
9.21.1. Checkpoint & Page Remapping
9.22. Stored Procedures as Views & Derived Tables
9.22.1. Procedure Table Parameters
9.22.2. Procedure Table Result Sets
9.22.3. Procedure Tables & Security
9.22.4. Procedure Table Cost and Join Order
9.22.5. Limitations
9.22.6. Procedure Table Examples
9.23. GRANT, REVOKE Statement
9.24. SET Statement
9.24.1. ISOLATION
9.24.2. LOCK_ESCALATION_PCT
9.24.3. transaction_timeout
9.24.4. PARAM_BATCH
9.25. Anytime Queries
9.26. Best Effort Union
9.27. Standard and User-Defined Aggregate Functions
9.27.1. Create Aggregate Statement
9.27.2. Drop Aggregate Statement
9.27.3. Examples of User-Defined Aggregates
9.28. Virtuoso SQL Optimization
9.28.1. Optimization Techniques
9.28.2. Query Options
9.28.3. Query Optimization Diagnostics
9.28.4. ANY ORDER
9.28.5. VDB Statistics for the SQL Compiler Collection
9.29. SQL Inverse Functions
9.29.1. Updating through Inverses
9.30. SQL Grammar
9.31. Bitmap Indices
9.31.1. Bitmap Indices and Transactions
9.31.2. Performance Implications
9.31.3. Physical Structure and Overheads
9.32. Transitivity in SQL
9.33. Fast Phrase Match Processor
9.33.1. Phrases, Phrase Sets and Phrase Classes
9.33.2. Phrase Set Configuration API
9.33.3. Advertisers and Advertisement Rules
9.33.4. Example
9.34. Geometry Data Types and Spatial Index Support
9.34.1. SQL MM Function Support
9.34.2. Spatial References
9.34.3. Geometric Objects
9.34.4. Well Known Text
9.34.5. Precision of Geometries
9.34.6. Predicates
9.34.7. Querying Geometric Relations
9.34.8. Defining a Geometry Index
9.34.9. Insert and Delete
9.34.10. Using Geometries in Client Applications and SQL Procedures
9.35. SQL Bulk Load, ELT, File Tables and Zero Load Operations
9.35.1. File Tables
9.35.2. Parallel Insert With File Tables and Transactions