8. SQL Reference
Chapter Contents
|
Prev
|
Next
Keyword Search:
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
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
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
8.1. Datatypes
8.1.1. Date Literals
8.1.2. Casting
8.1.3. Time & Date Manipulation
8.1.4. Declaring Collations of Expressions
8.2. User Defined Types
8.2.1. CREATE TYPE Statement
8.2.2. ALTER TYPE Statement
8.2.3. DROP TYPE Statement
8.2.4. CREATE METHOD Statement
8.2.5. Type Instances
8.2.6. Instance References
8.2.7. NEW Operator
8.2.8. Finding Methods - Method Signatures Generation & Comparison
8.2.9. Getting & Setting Member Values of Type Instances (member observers & mutators)
8.2.10. Calling Static Methods
8.2.11. Calling Instance Methods
8.2.12. Serializing & Deserializing Type Instances
8.2.13. User Defined Types Utility Functions
8.2.14. Hosted Foreign Objects in Virtuoso
8.2.15. Using User Defined Types to Represent SOAP Structures
8.2.16. Consuming Third-Party SOAP Services via User Defined Types
8.2.17. UDT Security
8.3. XML Column Type
8.4. Identifier Case & Quoting
8.5. Wide Character Identifiers
8.5.1. UTF-8 Implementation Notes For ODBC
8.5.2. UTF-8 Implementation Notes In JDBC
8.6. Qualified Names
8.6.1. Qualifiers and Owners
8.6.2. Default Qualifiers
8.6.3. USE Statement, USE identifier
8.7. Literals, Brace Escapes
8.7.1. Strings
8.7.2. Numbers
8.7.3. ODBC Brace Escapes
8.7.4. Hexadecimal Literals
8.7.5. Binary Literals
8.8. CREATE TABLE Statement
8.8.1. Syntax
8.8.2. NOT NULL
8.8.3. IDENTITY (Auto Increment)
8.8.4. DEFAULT
8.8.5. PRIMARY KEY Constraint
8.8.6. UNDER
8.8.7. FOREIGN KEY Constraint
8.8.8. The CHECK Constraint
8.8.9. The WITH SCHEMA Constraint
8.9. DROP TABLE Statement
8.10. CREATE INDEX Statement
8.11. DROP INDEX Statement
8.12. ALTER TABLE Statement
8.12.1. Adding a CHECK Constraint
8.13. CREATE VIEW Statement
8.14. CREATE XML SCHEMA Statement
8.15. DROP XML SCHEMA Statement
8.16. Sequence Objects
8.17. INSERT Statement
8.17.1. INSERT SOFT
8.17.2. INSERT REPLACING
8.18. UPDATE Statement
8.19. SELECT Statement
8.19.1. Syntax
8.19.2. Description
8.19.3. Column Aliasing - AS Declaration
8.19.4. Join examples
8.19.5. Ordering and Grouping
8.19.6. Derived Tables
8.19.7. Query Expressions
8.19.8. LIKE Predicate & Search Patterns
8.19.9. The TOP SELECT Option
8.19.10. CASE, NULLIF, COALESCE, CAST Value Expressions
8.19.11. SELECT BREAKUP
8.20. COMMIT WORK, ROLLBACK WORK Statement
8.21. CHECKPOINT, SHUTDOWN Statement
8.21.1. Checkpoint & Page Remapping
8.22. Stored Procedures as Views & Derived Tables
8.22.1. Procedure Table Parameters
8.22.2. Procedure Table Result Sets
8.22.3. Procedure Tables & Security
8.22.4. Procedure Table Cost and Join Order
8.22.5. Limitations
8.22.6. Procedure Table Examples
8.23. GRANT, REVOKE Statement
8.24. SET Statement
8.24.1. ISOLATION
8.24.2. LOCK_ESCALATION_PCT
8.24.3. transaction_timeout
8.24.4. PARAM_BATCH
8.25. Anytime Queries
8.26. Best Effort Union
8.27. Standard and User-Defined Aggregate Functions
8.27.1. Create Aggregate Statement
8.27.2. Drop Aggregate Statement
8.27.3. Examples of User-Defined Aggregates
8.28. Virtuoso SQL Optimization
8.28.1. Optimization Techniques
8.28.2. Query Options
8.28.3. ANY ORDER
8.28.4. VDB Statistics for the SQL Compiler Collection
8.29. SQL Inverse Functions
8.29.1. Updating through Inverses
8.30. SQL Grammar
8.31. Bitmap Indices
8.31.1. Bitmap Indices and Transactions
8.31.2. Performance Implications
8.31.3. Physical Structure and Overheads
8.32. Transitivity in SQL
8.33. Fast Phrase Match Processor
8.33.1. Phrases, Phrase Sets and Phrase Classes
8.33.2. Phrase Set Configuration API
8.33.3. Advertisers and Advertisement Rules
8.33.4. Example
Previous
Virtuoso Data Access Clients Connection Fail over and Load Balancing Support
Chapter Contents
Next
Datatypes