Next: Contents
Ovrimos version 3.0
On-line Documentation
Ovrimos S.A.
Ovrimos version 3.0
Copyright © 2000 Ovrimos S.A. All rights reserved.
All rights reserved. Ovrimos is a trademark of Ovrimos S.A. in Greece and other countries.
No part of this documentation may be reproduced, stored in a retrieval system, or transmitted
by any means, electronic, mechanical, photocopying, recording, desktop publishing,
or otherwise, without permission. No patent liability is assumed with respect to the use
of the information contained herein.
Ovrimos S.A. retains all ownership rights to the offered software programs and
related documentation. Copyright law limits the right to copy Ovrimos and this
documentation. Making unauthorized copies, adaptations, or compilation works
(except for archival purposes) is prohibited and constitutes a punishable violation
of the law.
THIS DOCUMENTATION IS PROVIDED ``AS IS'' WITHOUT WARRANTY OF ANY KIND.
IN NO EVENT SHALL OVRIMOS S.A. BE LIABLE FOR ANY LOSS OF PROFITS, LOSS OF BUSINESS,
LOSS OF USE OR DATA, INTERRUPTION OF BUSINESS, OR FOR ANY INDIRECT, SPECIAL,
INCIDENTAL, OR CONSEQUENTIAL DAMAGES OF ANY KIND, ARISING FROM ANY ERROR
IN THIS DOCUMENTATION.
Ovrimos S.A. may revise this documentation from time to time without notice.
Other product and company names mentioned herein may be the trademarks
of their respective owners.
Regular Expression Library
Copyright 1992, 1993, 1994 Henry Spencer. All rights reserved.
OpenSSL
Copyright (c) 1998-2000 The OpenSSL Project
Copyright (c) 1995-1998 Eric A. Young, Tim J. Hudson
All rights reserved.
- Contents
- List of Figures
- List of Tables
- 1. Introduction
- 2. Installation
- 3. Ovrimos Components
- 4. Database Manager
- 5. SQL Terminal
- 6. Roadmap
- 7. Administrator's Console
- 8. The HTTP server
- 9. SQL Query Tool
- 10. Connectivity
- 11. Replication
- 12. Database Maintenance
- 13. Database Security
- 14. Ovrimos Files and Configuration Parameters
- 15. Ovrimos SQL
- 15.1 Supported Data Types
- 15.2 Keywords
- 15.3 Sample Data
- 15.4 Supported SQL Statements
- 15.5 Standard SQL Functions
- 15.6 Supplemental SQL Functions
- 15.6.1 Mathematical functions
- IDENTITY(numeric_expression1, numeric_expression2)
- 15.6.2 Date and Time functions
- 15.6.3 String manipulation functions
- ASCII(string_expression)
- CHAR_LENGTH(string_expression)
- CHARACTER_LENGTH(string_expression)
- CONCAT(string_expression, string_expression)
- Concatenation Operator
- LCASE(string_expression)
- LENGTH(string_expression)
- LOCATE(string_expression1, string_expression2 [, start])
- LOWER(string_expression)
- LTRIM(string_expression)
- _CHAR(integer_expression)
- REPLACE(string_expression1, string_expression2,
string_expression3)
- RTRIM(string_expression)
- _INSERT(string_expression1, start, length, string_expression2)
- _LEFT(string_expression, count)
- _RIGHT(string_expression, count)
- _SUBSTRING(string_expression, start, length)
- UCASE(string_expression)
- UPPER(string_expression)
- 15.7 System functions
- 15.8 Regular Expression functions
- 16. Ovrimos SQL
- 16.1 Supported Data Types
- 16.2 Keywords
- 16.3 Sample Data
- 16.4 Supported SQL Statements
- 16.5 Standard SQL Functions
- 16.6 Supplemental SQL Functions
- 16.6.1 Mathematical functions
- IDENTITY(numeric_expression1, numeric_expression2)
- 16.6.2 Date and Time functions
- 16.6.3 String manipulation functions
- ASCII(string_expression)
- CHAR_LENGTH(string_expression)
- CHARACTER_LENGTH(string_expression)
- CONCAT(string_expression, string_expression)
- Concatenation Operator
- LCASE(string_expression)
- LENGTH(string_expression)
- LOCATE(string_expression1, string_expression2 [, start])
- LOWER(string_expression)
- LTRIM(string_expression)
- _CHAR(integer_expression)
- REPLACE(string_expression1, string_expression2,
string_expression3)
- RTRIM(string_expression)
- _INSERT(string_expression1, start, length, string_expression2)
- _LEFT(string_expression, count)
- _RIGHT(string_expression, count)
- _SUBSTRING(string_expression, start, length)
- UCASE(string_expression)
- UPPER(string_expression)
- 16.7 System functions
- 16.8 Regular Expression functions
- 17. Ovrimos SQL
- 17.1 Supported Data Types
- 17.2 Keywords
- 17.3 Sample Data
- 17.4 Supported SQL Statements
- 17.5 Standard SQL Functions
- 17.6 Supplemental SQL Functions
- 17.6.1 Mathematical functions
- IDENTITY(numeric_expression1, numeric_expression2)
- 17.6.2 Date and Time functions
- 17.6.3 String manipulation functions
- ASCII(string_expression)
- CHAR_LENGTH(string_expression)
- CHARACTER_LENGTH(string_expression)
- CONCAT(string_expression, string_expression)
- Concatenation Operator
- LCASE(string_expression)
- LENGTH(string_expression)
- LOCATE(string_expression1, string_expression2 [, start])
- LOWER(string_expression)
- LTRIM(string_expression)
- _CHAR(integer_expression)
- REPLACE(string_expression1, string_expression2,
string_expression3)
- RTRIM(string_expression)
- _INSERT(string_expression1, start, length, string_expression2)
- _LEFT(string_expression, count)
- _RIGHT(string_expression, count)
- _SUBSTRING(string_expression, start, length)
- UCASE(string_expression)
- UPPER(string_expression)
- 17.7 System functions
- 17.8 Regular Expression functions
- 17.9 BLOBs and the URI function
- 17.10 Storage and Retrieval of Unicode Data
- 17.11 Ovrimos databases
- 17.12 Bulk Updates
- 18. Persistent Stored Modules
- 19. Triggers
- 20. Examples and Utilities
- 21. Events
- 22. Ovrimos Error Messages
- Index
Next: Contents