Chapter 9. SQL Reference

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. Grouping Sets
9.19.7. Derived Tables
9.19.8. Query Expressions
9.19.9. LIKE Predicate & Search Patterns
9.19.10. The TOP SELECT Option
9.19.11. CASE, NULLIF, COALESCE, CAST Value Expressions
9.19.12. 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. Spatial References
9.34.2. Geometric Objects
9.34.3. Precision of Geometries
9.34.4. Predicates
9.34.5. Querying Geometric Relations
9.34.6. Defining a Geometry Index
9.34.7. Insert and Delete
9.34.8. Using Geometries in Client Applications and SQL Procedures
9.34.9. Virtuoso 7.1+ Geo Spatial Data type and function enhancements
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