- 0 -

0001

0002

0003

0004

0005

0006

0007

0008

0009

0010

0011

0012

0013

0014

0015

0016

0017

0018

0019

0020

0021

0022

0023

0024

0025

0026

0027

0028

0029

0030

0031

0032

0033

0034

0035

0036

0037

0038

0039

0040

0041

0042

0043

0044

0045

0046

0047

0048

0049

0050

0051

0052

0053

0054

0055

0056

0057

0058

0059

0060

0061

0062

0063

0064

0065

0066

0067

0068

0069

0070

0071

0072

0073

0074

0075

0078

0079

0089

0090

0091

0092

0093

0094

0095

0096

0097

0098

0099

0100

0101

0102

0103

0104

0105

0106

0107

0108

0109

0110

0111

0112

0113

0114

0115

0116

0117

0118

0119

0120

0121

0122

0123

0124

0125

0126

0127

0128

0129

0130

0131

0132

0134

0135

0136

0137

0138

0139

0140

0141

0142

0144

IconSDS-0143 "IN clause: field withouth index"
IconSDS-0144 "Table ID is wrong (<> 10 characters)"

0145

0146

0147

0148

0149

0150

0151

0152

0153

0154

0155

0156

0157

IconSDS-0157 "Error on segment obj drop"
IconSDS-0158 "Generic error on segment"
IconSDS-0159 "Pseudocolumn ROWID isn't allowed in query over segment"

- A -

ABS

IconNumeric Functions
IconABS

ACOS

ADD

IconADD SEGMENTOBJ
IconADD SNAPSHOTOBJ
IconALTER TABLE
IconCompendium of Sadas SQL Syntax

add column clauses

ADD SNAPSHOTOBJ

IconADD SEGMENTOBJ
IconADD SNAPSHOTOBJ

ADD_MONTHS

IconDatetime Functions
IconADD_MONTHS

Aggregate

Aggregate Functions

AGGREGATION

Alias name already used

Alias name is already a column name

ALL

IconAbout Queries and Subqueries
IconThe UNION [ALL], INTERSECT, MINUS Operators
IconDELETE STORED QUERIES
IconGRANT
IconGRANT TO ROLE
IconREVOKE
IconREVOKE FROM ROLE
IconSELECT
IconUNION
IconCompendium of Sadas SQL Syntax

Alphanumeric

ALTER

IconData Definition Language (DDL) Statements
IconALTER USER

ALTER TABLE

IconSQL DDL Clauses (constraint)
IconALTER TABLE
IconCompendium of Sadas SQL Syntax

ALTER USER

ALTER VIEW

IconALTER VIEW
IconCompendium of Sadas SQL Syntax

AND

IconCondition Precedence
IconComparison Conditions
IconSimple Comparison Conditions
IconLogical Conditions
IconRange Conditions

AND Truth Table

Antijoins

APPEND TABLE

IconAPPEND TABLE
IconCompendium of Sadas SQL Syntax

Arithmetic

Arithmetic Operators

AS

IconCREATE EXPRESSION
IconCREATE INDEX
IconCREATE TABLE
IconCREATE VIEW
IconDROP INDEX
IconSELECT

ASC

ASCII

IconBinary Comparisons
IconBlank-Padded Comparison Semantics
IconCharacter Functions Returning Numeric Values (COPY)
IconASCII

ASCII Character Set

ASIN

ATAN

AVG

IconAggregate Functions
IconAVG
IconSDS-0126 "Cannot nest more group functions"

- B -

Backus-Naur

Backus-Naur Form Syntax

Between

IconCondition Precedence
IconRange Conditions
IconSDS-0117 "Operands of different datatypes in between"

BIN_TO_NUM

Binary

Binary Operators

BITAND

BITOR

BITXOR

Blank-Padded

- C -

Cannot DROP current database

Cannot nest more group functions

Cartesian product

CASCADE

IconDELETE TABLE
IconDELETE KEYS

Case Expressions

Case Sensitivity

CEIL

IconNumeric Functions
IconCEIL[ING]

CEILING

IconNumeric Functions
IconCEIL[ING]

CHAR

IconSADAS Supported Datatypes
IconCharacter datatypes
IconCharacter Values
IconBinary Comparisons
IconBlank-Padded Comparison Semantics
IconCharacter Functions Returning Character Values

CHARACTER

IconSADAS Supported Datatypes
IconCharacter datatypes
IconCharacter Values
IconBinary Comparisons
IconBlank-Padded Comparison Semantics
IconCharacter Functions Returning Character Values

Character Functions

IconCharacter Functions Returning Character Values
IconCharacter Functions Returning Numeric Values (COPY)

CHARINDEX

CHR

IconCharacter Functions Returning Character Values
IconCHR

Code

IconSADAS Supported Datatypes
IconCode datatype
IconTO_BASE
IconTO_CODE
IconNull Conditions
IconSDS-0120 "Cannot use columns of code type as terms of an expression"

CODIFY

COLUMN

IconSimple Expressions
IconALTER TABLE
IconCOMMENT ON COLUMN
IconCREATE TABLE
IconLOAD COLUMNS
IconRENAME COLUMN
IconUPDATE COLUMNS

Column already exists

column clauses

column definition

IconALTER TABLE
IconCREATE TABLE

Column isn’t a PRIMARY KEY

Column not found in the sub-query of the FROM clause

COLUMNS

COMMENT

IconCOMMENT ON COLUMN
IconCOMMENT ON TABLE
IconCOMMENT ON SEGMENT
IconCOMMENT ON SEGMENTOBJ
IconCOMMENT ON SNAPSHOT
IconCOMMENT ON SNAPSHOTOBJ

Comments

Comparison Conditions

Compound Conditions

IconConditions
IconCompound Conditions

Compound Expressions

IconExpressions
IconAbout SQL Expressions
IconCompound Expressions

CONCAT

Concatenation

Concatenation Operators

CONDITION

Conditions

IconAbout SQL Conditions
IconCondition Precedence
IconComparison Conditions
IconSimple Comparison Conditions
IconLogical Conditions
IconPattern-matching Conditions

CONNECT

IconCONNECT
IconCompendium of Sadas SQL Syntax

CONNECT SYSDBA

IconCONNECT
IconCompendium of Sadas SQL Syntax

constant

CONSTRAINT

IconSQL DDL Clauses (constraint)
IconALTER TABLE

constraint clauses

Conversion Functions

Correlated Subquery

COS

COSH

COUNT

IconAggregate Functions
IconCOUNT

COUNT DISTINCT

CREATE

IconData Definition Language (DDL) Statements
IconCREATE DATABASE
IconCREATE DBADMIN
IconCREATE DOMAIN
IconCREATE EXPRESSION
IconCREATE INDEX
IconCREATE ROLE
IconCREATE SEGMENT
IconCREATE SNAPSHOT
IconCREATE SYNONYM
IconCREATE TABLE
IconCREATE USER
IconCREATE VIEW
IconSDS-0125 "Not supported syntax for CREATE VIEW statement"

CREATE DATABASE

IconCREATE DATABASE
IconCompendium of Sadas SQL Syntax

CREATE DBADMIN

CREATE DOMAIN

CREATE EXPRESSION

CREATE INDEX

CREATE ROLE

CREATE SNAPSHOT

IconCREATE SEGMENT
IconCREATE SNAPSHOT

CREATE SYNONYM

CREATE TABLE

IconSQL DDL Clauses (constraint)
IconALTER TABLE
IconCREATE TABLE

CREATE USER

IconCREATE USER
IconCompendium of Sadas SQL Syntax

CREATE VIEW

IconCREATE VIEW
IconSDS-0125 "Not supported syntax for CREATE VIEW statement"

CTL

CURDATE

IconCURDATE
IconSYSDATE

CURRENT_DATE

IconDatetime Functions
IconCURRENT_DATE

CURRENT_TIME

IconDatetime Functions
IconCURRENT_TIME

CURRENT_TIMESTAMP

IconDatetime Functions
IconCURRENT_TIMESTAMP

CURTIME

IconCURTIME
IconSYSTIME

Cyclic

- D -

Data are not compatible with the Server

Data Definition Language

IconTypes of SQL Statements
IconData Definition Language (DDL) Statements

Data Manipulation Language

IconTypes of SQL Statements
IconData Manipulation Language (DML) Statements

DATABASE

IconCommon Language for All Relational Databases
IconSchema/Database Objects
IconDEACTIVATE DATABASE
IconDEACTIVATE TABLE
IconDROP DATABASE
IconDUPLICATE DATABASE
IconIMPORT TABLE
IconLOAD DATABASE
IconREBUILD DATABASE
IconRENAME DATABASE
IconREPLICATE DATABASE
IconREWRITE DATABASE
IconTRUNCATE DATABASE
IconUNLOAD DATABASE

Database already exists

Database does not exist

Database ID already exists

Database ID is wrong (<> 10 characters)

DATATYPE

IconSADAS Datatypes
IconSADAS Supported Datatypes
IconCharacter datatypes
IconNumeric datatypes
IconDatetime datatypes
IconDATE Datatype
IconTIME Datatype
IconTIMESTAMP Datatype
IconCode datatype
IconDatatype Comparison Rules
IconNumeric Values
IconCharacter Values
IconBinary Comparisons
IconBlank-Padded Comparison Semantics
IconALTER TABLE
IconCREATE TABLE

DATE

IconSADAS Supported Datatypes
IconDatetime datatypes
IconDATE Datatype
IconDatetime Values
IconDatetime Literals
IconDatetime Functions
IconNull Conditions

DATE_TO_EXCEL

IconDATE_TO_EXCEL
IconEXCEL_TO_DATE
IconEXISTS_OBJECT

DATE_TO_JULIAN

IconDATE_TO_JULIAN
IconJULIAN_TO_DATE

DATE_TO_RATADIE

IconDATE_TO_RATADIE
IconRATADIE_TO_DATE

DATEADD

IconDatetime Functions
IconDATEADD

DATEDIFF

IconDatetime Functions
IconDATEDIFF

DATEPART

IconDatetime Functions
IconDATEPART

DATETIME

IconDatetime datatypes
IconDatetime Values
IconDatetime Literals

Datetime Expressions

IconExpressions
IconAbout SQL Expressions
IconDatetime Expressions

Datetime Functions

Datetime Literals

DAY

IconDatetime datatypes
IconDatetime Values

DAYNAME

IconDatetime Functions
IconDAYNAME

DAYOFWEEK

IconDatetime Functions
IconDAYOFWEEK

DAYOFYEAR

DAYOFYEAR4

days

IconALTER USER
IconCREATE USER

DB

IconCommon Language for All Relational Databases
IconCONNECT
IconCREATE DATABASE

DB NAME

IconCONNECT
IconCREATE DATABASE

DDL

IconSQL DDL Clauses (constraint)
IconTypes of SQL Statements
IconData Definition Language (DDL) Statements

DEACTIVATE

IconDEACTIVATE DATABASE
IconDEACTIVATE TABLE

DEACTIVATE DATABASE

IconDEACTIVATE DATABASE
IconDEACTIVATE TABLE

DEACTIVATE TABLE

IconDEACTIVATE DATABASE
IconDEACTIVATE TABLE

DEC

DEC 

IconSADAS Supported Datatypes
IconNumeric datatypes
IconNumeric Values

DECIMAL

DECIMAL 

IconSADAS Supported Datatypes
IconNumeric datatypes
IconNumeric Values

DECIMALS

DECODE

IconEncoding and Decoding Functions
IconDECODE

DECODE function: default parameter must be constant

DELETE

IconData Manipulation Language (DML) Statements
IconDELETE STORED QUERIES
IconDELETE TABLE
IconCompendium of Sadas SQL Syntax
IconSDS-0124 "Too many tables in DELETE statement"
IconSDS-0130 "DELETE KEYS statement is not allowed on a view"

DELETE KEYS

IconDELETE KEYS
IconCompendium of Sadas SQL Syntax
IconSDS-0124 "Too many tables in DELETE statement"
IconSDS-0130 "DELETE KEYS statement is not allowed on a view"

DELETE KEYS statement is not allowed on a view

DELETE STORED QUERIES

IconDELETE STORED QUERIES
IconCompendium of Sadas SQL Syntax

DELETE TABLE

DESC

IconDESCRIBE STORED QUERIES
IconDESCRIBE SYSALLCOLUMNS
IconDESCRIBE SYSDB
IconDESCRIBE SYSDOMAINS
IconDESCRIBE SYSFOREIGNKEYS
IconDESCRIBE SYSKEYS
IconDESCRIBE SYSLOG
IconDESCRIBE SYSOBJECTS
IconDESCRIBE SYSROLES
IconDESCRIBE SYSSEGMENTOBJS
IconDESCRIBE SYSSEGMENTS
IconDESCRIBE SYSSNAPSHOTOBJS
IconDESCRIBE SYSSNAPSHOTS
IconDESCRIBE SYSSYNONYMS
IconDESCRIBE SYSTABLES
IconDESCRIBE SYSUSERS
IconDESCRIBE SYSVIEWS
IconDESCRIBE TABLE
IconDESCRIBE USER
IconSELECT
IconCompendium of Sadas SQL Syntax

DESC SYSALLCOLUMNS

DESC SYSDB

DESC SYSDOMAINS

DESC SYSFOREIGNKEYS

IconSQL DDL Clauses (constraint)
IconDESCRIBE SYSFOREIGNKEYS

DESC SYSKEYS

IconSQL DDL Clauses (constraint)
IconDESCRIBE SYSKEYS

DESC SYSLOG

DESC SYSOBJECTS

DESC SYSROLES

DESC SYSSNAPSHOTOBJS

IconDESCRIBE SYSSEGMENTOBJS
IconDESCRIBE SYSSNAPSHOTOBJS

DESC SYSSNAPSHOTS

IconDESCRIBE SYSSEGMENTS
IconDESCRIBE SYSSNAPSHOTS

DESC SYSSYNONYMS

DESC SYSTABLES

DESC SYSUSERS

DESC SYSVIEWS

DESC USER

DESCR

IconDESCRIBE STORED QUERIES
IconDESCRIBE SYSALLCOLUMNS
IconDESCRIBE SYSDB
IconDESCRIBE SYSDOMAINS
IconDESCRIBE SYSFOREIGNKEYS
IconDESCRIBE SYSKEYS
IconDESCRIBE SYSLOG
IconDESCRIBE SYSOBJECTS
IconDESCRIBE SYSROLES
IconDESCRIBE SYSSEGMENTOBJS
IconDESCRIBE SYSSEGMENTS
IconDESCRIBE SYSSNAPSHOTOBJS
IconDESCRIBE SYSSNAPSHOTS
IconDESCRIBE SYSSYNONYMS
IconDESCRIBE SYSTABLES
IconDESCRIBE SYSUSERS
IconDESCRIBE SYSVIEWS
IconDESCRIBE TABLE
IconDESCRIBE USER
IconCompendium of Sadas SQL Syntax

DESCRIBE

IconDESCRIBE SEGMENT
IconDESCRIBE SNAPSHOT
IconDESCRIBE STORED QUERIES
IconDESCRIBE SYSALLCOLUMNS
IconDESCRIBE SYSDB
IconDESCRIBE SYSDOMAINS
IconDESCRIBE SYSFOREIGNKEYS
IconDESCRIBE SYSKEYS
IconDESCRIBE SYSLOG
IconDESCRIBE SYSOBJECTS
IconDESCRIBE SYSROLES
IconDESCRIBE SYSSEGMENTOBJS
IconDESCRIBE SYSSEGMENTS
IconDESCRIBE SYSSNAPSHOTOBJS
IconDESCRIBE SYSSNAPSHOTS
IconDESCRIBE SYSSYNONYMS
IconDESCRIBE SYSTABLES
IconDESCRIBE SYSUSERS
IconDESCRIBE SYSVIEWS
IconDESCRIBE TABLE
IconDESCRIBE USER
IconCompendium of Sadas SQL Syntax

DESCRIBE SNAPSHOT

IconDESCRIBE SEGMENT
IconDESCRIBE SNAPSHOT

DESCRIBE STORED QUERIES

DESCRIBE SYSALLCOLUMNS

DESCRIBE SYSDB

DESCRIBE SYSDOMAINS

DESCRIBE SYSFOREIGNKEYS

DESCRIBE SYSKEYS

DESCRIBE SYSLOG

DESCRIBE SYSOBJECTS

DESCRIBE SYSROLES

DESCRIBE SYSSNAPSHOTOBJS

IconDESCRIBE SYSSEGMENTOBJS
IconDESCRIBE SYSSNAPSHOTOBJS

DESCRIBE SYSSNAPSHOTS

IconDESCRIBE SYSSEGMENTS
IconDESCRIBE SYSSNAPSHOTS

DESCRIBE SYSSYNONYMS

DESCRIBE SYSTABLES

DESCRIBE SYSUSERS

DESCRIBE SYSVIEWS

DESCRIBE TABLE

DESCRIBE USER

Diagrams

IconGraphic Syntax Diagrams
IconRequired Keywords and Parameters
IconOptional Keywords and Parameters
IconSyntax Loops
IconMultipart Diagrams

DIGIT

IconInteger Literals
IconNUMBER and Floating-Point Literals

DIGITS

IconDIGITS
IconSDS-0141 "DIGITS function allows only one integer column"

DIGITS function allows only one integer column

DIRECT

IconAPPEND TABLE
IconINSERT TABLE
IconLOAD TABLE
IconREWRITE TABLE
IconCompendium of Sadas SQL Syntax

DISABLE

IconDISABLE INDEX
IconDISABLE INDEXES
IconDISABLE INDEXGBY

DISABLE INDEXGBY

IconDISABLE INDEX
IconDISABLE INDEXES
IconDISABLE INDEXGBY
IconCompendium of Sadas SQL Syntax

DISC

IconDISCONNECT
IconCompendium of Sadas SQL Syntax

DISCONNECT

IconDISCONNECT
IconCompendium of Sadas SQL Syntax

DISTINCT

IconAbout Queries and Subqueries
IconSorting Query Results
IconSELECT
IconCompendium of Sadas SQL Syntax

DISTRIBUTE

IconSELECT
IconCompendium of Sadas SQL Syntax

Division by zero

DML

IconTypes of SQL Statements
IconData Manipulation Language (DML) Statements

DOMAIN

IconCREATE DOMAIN
IconDESCRIBE SYSROLES
IconDROP DOMAIN
IconRENAME DOMAIN

Domain already exists

Domain does not exist

domain name

IconCREATE DOMAIN
IconCREATE USER
IconDESCRIBE SYSUSERS

Domain not enabled for user

DOUBLE PRECISION

IconSADAS Supported Datatypes
IconNumeric datatypes
IconNumeric Values

DROP

IconData Definition Language (DDL) Statements
IconALTER TABLE
IconDROP DATABASE
IconDROP DOMAIN
IconDROP EXPRESSION
IconDROP EXPRESSIONS
IconDROP GENERATED COLUMNS
IconDROP INDEX
IconDROP ROLE
IconDROP SEGMENT
IconDROP SNAPSHOT
IconDROP SEGMENTOBJ
IconDROP SNAPSHOTOBJ
IconDROP SYNONYM
IconDROP TABLE
IconDROP USER
IconDROP VIEW

DROP COLUMN

IconALTER TABLE
IconCompendium of Sadas SQL Syntax

drop column clause

DROP DATABASE

IconDROP DATABASE
IconCompendium of Sadas SQL Syntax

DROP DOMAIN

DROP EXPRESSION

IconDROP EXPRESSION
IconDROP EXPRESSIONS

DROP EXPRESSIONS

IconDROP EXPRESSION
IconDROP EXPRESSIONS

DROP GENERATED COLUMNS

DROP INDEX

DROP ROLE

DROP SEGMENT

DROP SNAPSHOT

DROP SNAPSHOTOBJ

IconDROP SEGMENTOBJ
IconDROP SNAPSHOTOBJ

DROP SYNONYM

DROP TABLE

IconDROP TABLE
IconCompendium of Sadas SQL Syntax

DROP USER

IconDROP USER
IconCompendium of Sadas SQL Syntax

DROP VIEW

IconDROP VIEW
IconCompendium of Sadas SQL Syntax

DUAL

IconSelecting from the DUAL Table
IconSDS-0127 "In DUAL SELECT the following clause is not allowed"

DUAL Table

DUPLICATE

IconDUPLICATE DATABASE
IconDUPLICATE TABLE
IconDUPLICATE USER

DUPLICATE DATABASE

IconDUPLICATE DATABASE
IconCompendium of Sadas SQL Syntax

Duplicate FOREIGN KEY

DUPLICATE TABLE

IconDUPLICATE TABLE
IconCompendium of Sadas SQL Syntax

DUPLICATE USER

IconDUPLICATE USER
IconCompendium of Sadas SQL Syntax

- E -

EBCDIC

IconBinary Comparisons
IconBlank-Padded Comparison Semantics

EBCDIC Character Set

ELSE

ENABLE

IconENABLE INDEX
IconENABLE INDEXES
IconENABLE INDEXGBY
IconEXISTS OBJECT

ENABLE INDEXBGY

ENABLE INDEXGBY

IconENABLE INDEX
IconENABLE INDEXES
IconENABLE INDEXGBY
IconEXISTS OBJECT

Encoding and Decoding Functions

Encountered end of file in comments

END

ENGLISH

Equijoins

IconJoin Conditions
IconEquijoins

Error on segment obj create

Error on segment obj drop

IconSDS-0157 "Error on segment obj drop"
IconSDS-0158 "Generic error on segment"
IconSDS-0159 "Pseudocolumn ROWID isn't allowed in query over segment"

Error on snapshot obj create

Error on snapshot obj drop

Exceeded the limit of the number precision

EXCEL_TO_DATE

IconDATE_TO_EXCEL
IconEXCEL_TO_DATE
IconEXISTS_OBJECT

EXEC

IconEXECUTE STORED QUERIES
IconCompendium of Sadas SQL Syntax

EXECUTE

EXECUTE STORED QUERIES

EXECUTE STORED QUERUES

EXISTS

IconCondition Precedence
IconEXISTS Condition

EXISTS Condition

IconConditions
IconEXISTS Condition

EXP

Expected a constant positive expression in column definition

Expected arithmetic operator

Expected identifier after point

Expected identifier or constant value

Expected logical operator

Expected relational operator

Expression

IconIN Condition
IconCREATE EXPRESSION
IconDROP EXPRESSION
IconDROP EXPRESSIONS
IconSDS-0120 "Cannot use columns of code type as terms of an expression"

Expression Lists

IconExpressions
IconAbout SQL Expressions
IconExpression Lists

EXPRESSIONS

IconExpressions
IconAbout SQL Expressions
IconSimple Expressions
IconCompound Expressions
IconCase Expressions
IconDatetime Expressions
IconFunction Expressions
IconScalar Subquery Expressions
IconExpression Lists
IconDROP EXPRESSION
IconDROP EXPRESSIONS

External function

External function error

External function not found in Catalog

EXTFUNC

- F -

FILE NAME

IconINSERT TABLE
IconLOAD COLUMNS
IconLOAD TABLE
IconREWRITE TABLE
IconUNLOAD TABLE
IconUPDATE COLUMNS
IconUPDATE TABLE

FIRST_DAY

FIRST_WORK_DAY

FLOAT

FLOAT 

IconSADAS Supported Datatypes
IconNumeric datatypes
IconNumeric Values

FLOOR

IconNumeric Functions
IconFLOOR

Fmt

FOREIGN KEY

IconSQL DDL Clauses (constraint)
IconForeign Key Constraints
IconALTER TABLE
IconALTER VIEW

Foreign Key Constraints

FROM

IconAbout Queries and Subqueries
IconDELETE TABLE
IconDELETE KEYS
IconREVOKE
IconREVOKE FROM ROLE
IconSELECT
IconCompendium of Sadas SQL Syntax

FROM clause

FULL

FULL JOIN

FULL OUTER JOIN

function

Function ABS

Function ACOS

Function ADD_MONTHS

Function ASCII

Function ASIN

Function ATAN

Function AVG

Function BIN_TO_NUM

Function BITAND

Function BITOR

Function BITXOR

Function CEIL

Function CHARINDEX

Function CHR

Function CODIFY

Function CONCAT

Function COS

Function COSH

Function COUNT

Function CURRENT_DATE

Function CURRENT_TIME

Function CURRENT_TIMESTAMP

Function DATE_TO_EXCEL

IconDATE_TO_EXCEL
IconEXCEL_TO_DATE
IconEXISTS_OBJECT

Function DATE_TO_JULIAN

IconDATE_TO_JULIAN
IconJULIAN_TO_DATE

Function DATE_TO_RATADIE

IconDATE_TO_RATADIE
IconRATADIE_TO_DATE

Function DATEADD

Function DATEDIFF

Function DATEPART

Function DAYNAME

Function DAYOFWEEK

Function DAYOFYEAR

Function DECODE

Function DIGITS

Function EXCEL_TO_DATE

IconDATE_TO_EXCEL
IconEXCEL_TO_DATE
IconEXISTS_OBJECT

Function EXP

Function Expressions

IconExpressions
IconAbout SQL Expressions
IconFunction Expressions

Function FIRST_DAY

Function FIRST_WORK_DAY

Function FLOOR

Function GREATEST

Function GROUPING

Function HEXTONUM

Function HEXTOSTR

Function HHMM_TO_MINUTE

Function INITCAP

Function INSTR

IconINSTR
IconPOSITION
IconREGEXP_INSTR

Function ISNUMERIC

Function JULIAN_TO_DATE

IconDATE_TO_JULIAN
IconJULIAN_TO_DATE

Function LAST_DAY

Function LAST_WORK_DAY

Function LEAST

Function LENGTH

Function LN

Function LOG

Function LOWER

IconLCASE
IconLOWER

Function LPAD

Function LTRIM

Function MAX

Function MIN

Function MINUTE_TO_HHMM

Function MOD

IconMOD
IconREMAINDER

Function MONTHNAME

Function MONTHS_BETWEEN

Function NEXT_DAY

Function NEXT_WORK_DAY

Function not available in this Sadas version

Function NUMTOHEX

Function PI

Function POWER

Function PREVIOUS_DAY

Function PREVIOUS_WORK_DAY

Function RATIO_TO_REPORT

Function REPLACE

IconREGEXP_REPLACE
IconREPLACE

Function REPLICATE

Function REVERSE

Function ROUND

Function RPAD

Function RTRIM

Function SDS_HASH

Function SDS_HASH_Sh1

Function SHUFFLE

Function SIGN

Function SIN

Function SINH

Function SOUNDEX

Function SPACE

Function SQRT

Function STDDEV

Function STRTOHEX

Function SUBSTITUTE_WITH

Function SUBSTR

IconREGEXP_SUBSTR
IconSUBSTR[ING]

Function SUM

Function SYSDATE

IconCURDATE
IconSYSDATE

Function SYSTIME

IconCURTIME
IconSYSTIME

Function SYSTIMESTAMP

IconLOCALTIMESTAMP
IconNOW
IconSYSTIMESTAMP

Function TAN

Function TANH

Function TO_BASE

Function TO_CHAR(character)

Function TO_CHAR(datetime)

Function TO_CHAR(number)

Function TO_CODE

Function TO_DATE

Function TO_DESC

Function TO_NUMBER

Function TO_TIME

Function TO_TIMESTAMP

Function TODAY

Function TRANSLATE

Function TRIM

Function TRUNC(number)

Function UPPER

IconUCASE
IconUPPER

Function VARIANCE

Function VSIZE

IconIS_FIRST
IconVSIZE

function: invalid date/time format model

Functions

IconSQL Functions
IconAbout SQL Functions
IconSingle-Row Functions
IconNumeric Functions
IconCharacter Functions Returning Character Values
IconCharacter Functions Returning Numeric Values (COPY)
IconDatetime Functions
IconGeneral Comparison Functions
IconConversion Functions
IconEncoding and Decoding Functions
IconAggregate Functions
IconABS
IconACOS
IconADD_MONTHS
IconASCII
IconASIN
IconATAN
IconAVG
IconBIN_TO_NUM
IconBITAND
IconBITOR
IconBITXOR
IconCEIL[ING]
IconCHARINDEX
IconCHR
IconCODIFY
IconCONCAT
IconCOS
IconCOSH
IconCOUNT
IconCURDATE
IconCURRENT_DATE
IconCURRENT_TIME
IconCURRENT_TIMESTAMP
IconCURTIME
IconDATEADD
IconDATEDIFF
IconDATEPART
IconDATE_TO_EXCEL
IconDATE_TO_JULIAN
IconDATE_TO_RATADIE
IconDAYNAME
IconDAYOFWEEK
IconDAYOFYEAR
IconDECODE
IconDIGITS
IconEXCEL_TO_DATE
IconEXISTS_OBJECT
IconEXP
IconEXTFUNC
IconFIRST_DAY
IconFIRST_WORK_DAY
IconFLOOR
IconGREATEST
IconGROUPING
IconHEXTONUM
IconHEXTOSTR
IconHHMM_TO_MINUTE
IconINITCAP
IconINSTR
IconIS_FIRST
IconJULIAN_TO_DATE
IconISNUMERIC
IconLAST_DAY
IconLAST_WORK_DAY
IconLCASE
IconLEAST
IconLENGTH
IconLN
IconLOCALTIMESTAMP
IconLOG
IconLOWER
IconLPAD
IconLTRIM
IconMAX
IconMIN
IconMINUTE_TO_HHMM
IconMOD
IconMONTHNAME
IconMONTHS_BETWEEN
IconNEXT_DAY
IconNEXT_WORK_DAY
IconNOW
IconNUMTOHEX
IconPI
IconPOSITION
IconPOWER
IconPREVIOUS_DAY
IconPREVIOUS_WORK_DAY
IconRATADIE_TO_DATE
IconRATIO_TO_REPORT
IconREGEXP_INSTR
IconREGEXP_REPLACE
IconREGEXP_SUBSTR
IconREMAINDER
IconREPLACE
IconREPLICATE
IconREVERSE
IconROUND
IconRPAD
IconRTRIM
IconSDS_HASH
IconSDS_HASH_SH1
IconSIGN
IconSIN
IconSINH
IconSHUFFLE
IconSOUNDEX
IconSPACE
IconSQRT
IconSTDDEV
IconSTRTOHEX
IconSUBSTITUTE_WITH
IconSUBSTR[ING]
IconSUM
IconSYSDATE
IconSYSTIME
IconSYSTIMESTAMP
IconTAN
IconTANH
IconTO_BASE
IconTO_CHAR (character)
IconTO_CHAR (datetime)
IconTO_CHAR (number)
IconTO_CODE
IconTO_DATE
IconTO_DESC
IconTO_NUMBER
IconTO_TIME
IconTO_TIMESTAMP
IconTODAY
IconTRANSLATE
IconTRIM
IconTRUNC[ATE] (number)
IconUCASE
IconUPPER
IconVARIANCE
IconVSIZE

- G -

GENERATED

GLOBAL TEMPORARY

IconCREATE TABLE
IconCompendium of Sadas SQL Syntax

GRANT

IconData Definition Language (DDL) Statements
IconGRANT

GRANT ALL

IconGRANT
IconGRANT TO ROLE
IconCompendium of Sadas SQL Syntax

GRANT TO ROLE

Graphic Syntax Diagrams

GREATEST

IconGeneral Comparison Functions
IconGREATEST

GROUP BY

IconSELECT
IconCompendium of Sadas SQL Syntax
IconSDS-0127 "In DUAL SELECT the following clause is not allowed"

GROUP BY CLAUSE

IconAbout SQL Expressions
IconAbout Queries and Subqueries
IconSorting Query Results

GROUP BY clause required in this case

GROUP FUNCTION

GROUPING

- H -

HAVING

IconAbout Queries and Subqueries
IconSELECT
IconCompendium of Sadas SQL Syntax

HAVING CLAUSE

IconAbout SQL Expressions
IconAbout SQL Conditions
IconCondition Precedence
IconComparison Conditions
IconSimple Comparison Conditions
IconLogical Conditions

HEXTONUM

HEXTOSTR

HHMM_TO_MINUTE

IconHHMM_TO_MINUTE
IconMINUTE_TO_HHMM
IconSDS-0146 "HHMM_TO_MINUTE function: unable to convert the string"
IconSDS-0147 "MINUTE_TO_HHMM function: wrong value"

HHMM_TO_MINUTE function

IconSDS-0146 "HHMM_TO_MINUTE function: unable to convert the string"
IconSDS-0147 "MINUTE_TO_HHMM function: wrong value"

HOUR

IconDatetime datatypes
IconDatetime Values

- I -

Identifier name too long

Illegal DISTINCT clause

Illegal DISTRIBUTE clause

Illegal function in the context

Illegal GROUP BY clause

Illegal HAVING clause

Illegal identifier

Illegal identifier: the first character must be a letter

Illegal numeric literal

Illegal operation on operands

Illegal ORDER BY clause

Illegal UNION [ALL]/INTERSECT/MINUS

Illegal use of aggregate function

Illegal use of function TRANSLATE

Improper use of alias name

Improper use of DISTINCT clause

Improper use of INFO/SHADOW keywords

IN

IconCondition Precedence
IconIN Condition
IconSDS-0118 "IN clause: operands of different datatypes in the list of constants"
IconSDS-0143 "IN clause: field withouth index"

IN clause: expected constant expression

IN clause: field withouth index

IN Condition

IconConditions
IconIN Condition

In DUAL SELECT following clause is not allowed

INDEX

IconCREATE INDEX
IconDROP INDEX

Indexed Columns

Indexes

INDEXGBY

IconDISABLE INDEX
IconDISABLE INDEXES
IconDISABLE INDEXGBY
IconENABLE INDEX
IconENABLE INDEXES
IconENABLE INDEXGBY
IconEXISTS OBJECT

INFO

IconDESCRIBE TABLE
IconCompendium of Sadas SQL Syntax
IconGraphic Syntax Diagrams

INITCAP

IconCharacter Functions Returning Character Values
IconINITCAP

inline view

INNER JOIN

IconJoin Conditions
IconSelf Joins
IconSpecial notes
IconSELECT

INSERT

INSERT TABLE

INSERT: wrong number of constants

INSERT: wrong type of a constant

INSTR

IconCharacter Functions Returning Numeric Values (COPY)
IconINSTR
IconPOSITION
IconREGEXP_INSTR

INT 

IconSADAS Supported Datatypes
IconNumeric datatypes
IconNumeric Values

INTEGER

INTEGER 

IconSADAS Supported Datatypes
IconNumeric datatypes
IconNumeric Values

integrity constraint

Internal error; analyze the context!

Internal error; undefined type; analyze the context!

INTERSECT

IconSet Operators
IconAbout Queries and Subqueries
IconThe UNION [ALL], INTERSECT, MINUS Operators
IconINTERSECT
IconSELECT
IconCompendium of Sadas SQL Syntax

Invalid column description

Invalid constraint

Invalid NOT STAR JOIN

Invalid numeric value for the function

ISNUMERIC

ITALIAN

- J -

Join

IconJoins
IconSDS-0119 "Join graph not supported"

Join clause

Join Conditions

JULIAN_TO_DATE

IconDATE_TO_JULIAN
IconJULIAN_TO_DATE

- K -

KEY

KEYS

Keywords

IconRequired Keywords and Parameters
IconOptional Keywords and Parameters

- L -

LANGUAGE

LAST_DAY

IconDatetime Functions
IconLAST_DAY

LAST_WORK_DAY

LCASE

IconLCASE
IconLOWER

LEAST

IconGeneral Comparison Functions
IconLEAST

LEFT

LEFT JOIN

LEFT OUTER JOIN

LEFTNULL

LENGTH

IconCharacter Functions Returning Numeric Values (COPY)
IconLENGTH

Lexical

Lexical Conventions

Like

IconCondition Precedence
IconCase Sensitivity
IconPattern Matching on Indexed Columns
IconSDS-0116 "LIKE works only on alphanumeric columns"

LIKE Conditions

IconLIKE Condition
IconLIKE Condition: General Examples

Literals

IconLiterals
IconText Literals
IconNumeric Literals
IconInteger Literals
IconNUMBER and Floating-Point Literals
IconDatetime Literals

LN

LOAD

IconData Definition Language (DDL) Statements
IconLOAD COLUMNS
IconLOAD DATABASE

LOAD COLUMN

IconLOAD COLUMNS
IconCompendium of Sadas SQL Syntax

LOAD DATABASE

IconLOAD DATABASE
IconCompendium of Sadas SQL Syntax

LOAD TABLE

IconLOAD TABLE
IconCompendium of Sadas SQL Syntax

LOCALTIMESTAMP

IconLOCALTIMESTAMP
IconSYSTIMESTAMP

LOCK

IconLOCK TABLE
IconLOCK USER
IconSDS-0140 "Table locked"

LOCK TABLE

LOCK USER

LOG

Logical Conditions

IconConditions
IconLogical Conditions

LOKE

IconLIKE Condition
IconLIKE Condition: General Examples

Loops

LOWER

IconCharacter Functions Returning Character Values
IconLCASE
IconLOWER

LPAD

IconCharacter Functions Returning Character Values
IconLPAD

LPAD/RPAD functions: the second parameter must be a not negative integer constant

LPAD/RPAD functions: the third parameter must be a char

LTRIM

IconCharacter Functions Returning Character Values
IconLTRIM

- M -

MATERIALIZATED VIEW

MATERIALIZED

materialized view

MAX

IconAggregate Functions
IconMAX
IconSDS-0126 "Cannot nest more group functions"

MILLISECOND

IconDatetime datatypes
IconDatetime Values

MIN

IconAggregate Functions
IconMIN
IconSDS-0126 "Cannot nest more group functions"

MINUS

IconSet Operators
IconAbout Queries and Subqueries
IconThe UNION [ALL], INTERSECT, MINUS Operators
IconMINUS
IconSELECT
IconCompendium of Sadas SQL Syntax

MINUTE

IconDatetime datatypes
IconDatetime Values

MINUTE_TO_HHMM

IconHHMM_TO_MINUTE
IconMINUTE_TO_HHMM
IconSDS-0146 "HHMM_TO_MINUTE function: unable to convert the string"
IconSDS-0147 "MINUTE_TO_HHMM function: wrong value"

MINUTE_TO_HHMM function

IconSDS-0146 "HHMM_TO_MINUTE function: unable to convert the string"
IconSDS-0147 "MINUTE_TO_HHMM function: wrong value"

MOD

IconNumeric Functions
IconMOD
IconREMAINDER

MODIFY

IconSQL DDL Clauses (constraint)
IconALTER TABLE
IconALTER VIEW
IconCompendium of Sadas SQL Syntax

modify col properties

modify column clauses

MODIFY CONSTRAINT Clause

MONTH

IconDatetime datatypes
IconDatetime Values

MONTHNAME

IconDatetime Functions
IconMONTHNAME

MONTHS_BETWEEN

IconDatetime Functions
IconMONTHS_BETWEEN

MOUNT

IconMOUNT SNAPSHOT
IconUNMOUNT SNAPSHOT

MOUNT SNAPSHOT

IconMOUNT SNAPSHOT
IconUNMOUNT SNAPSHOT

Multipart Diagrams

- N -

Nested Subquery

IconUsing Subqueries
IconUnnesting of Nested Subqueries

NEXT_DAY

IconDatetime Functions
IconNEXT_DAY

NEXT_WORK_DAY

NLS_CALENDAR

NLS_CHARACTERSET

NLS_COMP

NLS_CURRENCY

IconTO_CHAR (datetime)
IconTO_CHAR (number)

NLS_DATE_FORMAT

NLS_DATE_LANGUAGE

NLS_DUAL_CURRENCY

NLS_ISO_CURRENCY

IconTO_CHAR (datetime)
IconTO_CHAR (number)

NLS_LANGUAGE

NLS_LENGTH_SEMANTICS

NLS_NCHAR_CHARACTER_SET

NLS_NCHAR_CONV_EXCP

NLS_NUMERIC_CHARACTERS

IconTO_CHAR (datetime)
IconTO_CHAR (number)

NLS_RDBMS_VERSION

NLS_SORT

NLS_TERRITORY

NLS_TIME_FORMAT

NLS_TIME_TZ_FORMAT

NLS_TIMESTAMP_FORMAT

NLS_TIMESTAMP_TZ_FORMAT

No database available

No error

No user connected

Non executable SQL

Nonpadded

NOT

IconCondition Precedence
IconComparison Conditions
IconSimple Comparison Conditions
IconLogical Conditions
IconLIKE Condition
IconLIKE Condition: General Examples
IconRange Conditions

NOT IN

NOT STAR JOIN

IconJoin Conditions
IconSELECT

Not supported syntax for CREATE VIEW statement

Not terminated text literal

NOT Truth Table

NOW

IconNOW
IconSYSTIMESTAMP

NULL

Null Conditions

IconConditions
IconNull Conditions

Null identifier

Null SQL script

NUMBER

NUMBER 

IconSADAS Supported Datatypes
IconNumeric datatypes
IconNumeric Values

NUMERIC

IconNull Conditions
IconGraphic Syntax Diagrams

Numeric Literals

IconNumeric Literals
IconInteger Literals
IconNUMBER and Floating-Point Literals

NUMERIC 

IconSADAS Supported Datatypes
IconNumeric datatypes
IconNumeric Values

NUMTOHEX

- O -

ON

IconCREATE EXPRESSION
IconCREATE INDEX
IconRENAME COLUMN

ONLY

IconAPPEND TABLE
IconINSERT TABLE
IconLOAD TABLE
IconREWRITE TABLE
IconUNLOAD TABLE

Operands of different datatypes

Operator

Operator Precedence

Operators

IconOperators
IconAbout SQL Operators
IconUnary and Binary Operators
IconArithmetic Operators
IconConcatenation Operators
IconSet Operators

Optional Keywords

OR

IconCondition Precedence
IconComparison Conditions
IconSimple Comparison Conditions
IconLogical Conditions

OR Truth Table

ORDER BY

IconAPPEND TABLE
IconSELECT
IconCompendium of Sadas SQL Syntax
IconSDS-0127 "In DUAL SELECT the following clause is not allowed"

ORDER BY CLAUSE

IconAbout SQL Expressions
IconAbout Queries and Subqueries

Outer Joins

IconJoin Conditions
IconSpecial outer joins

- P -

Parameters

IconRequired Keywords and Parameters
IconOptional Keywords and Parameters

PASSWORD

IconALTER USER
IconCONNECT
IconCREATE USER

PASWORD_LIFE_TIME

IconALTER USER
IconCREATE USER

Pattern-matching Conditions

PI

POSITION

IconINSTR
IconPOSITION
IconREGEXP_INSTR

POWER

IconNumeric Functions
IconPOWER

PR_CATALOG

IconGRANT
IconGRANT TO ROLE
IconREVOKE
IconREVOKE FROM ROLE
IconCompendium of Sadas SQL Syntax

PR_DESCRIBE

IconGRANT
IconGRANT TO ROLE
IconREVOKE
IconREVOKE FROM ROLE
IconCompendium of Sadas SQL Syntax

PR_LOAD

IconGRANT
IconGRANT TO ROLE
IconREVOKE
IconREVOKE FROM ROLE
IconCompendium of Sadas SQL Syntax

PR_SECURITY

IconGRANT
IconGRANT TO ROLE
IconREVOKE
IconREVOKE FROM ROLE
IconCompendium of Sadas SQL Syntax

PR_SELECT

IconGRANT
IconGRANT TO ROLE
IconREVOKE
IconREVOKE FROM ROLE
IconCompendium of Sadas SQL Syntax

PREVIOUS_DAY

IconPREVIOUS_DAY
IconSDS-0142 "Wrong use of function PREVIOUS_DAY"

PREVIOUS_WORK_DAY

PRIMARY KEY

IconSQL DDL Clauses (constraint)
IconPrimary Key Constraints
IconALTER TABLE
IconALTER VIEW

Primary Key Constraints

Primary key is not unique

PRIVILAGE LIST

privileges list

IconGRANT
IconGRANT TO ROLE
IconREVOKE FROM ROLE

Pseudocolumn

IconPseudocolumns
IconROWID Pseudocolumn
IconROWNUM Pseudocolumn

- Q -

QUERIES

IconDELETE STORED QUERIES
IconDESCRIBE STORED QUERIES
IconEXECUTE STORED QUERIES

QUERY

IconSQL Queries and Subqueries
IconAbout Queries and Subqueries
IconCreating Simple Queries
IconThe UNION [ALL], INTERSECT, MINUS Operators
IconSELECT

query_block

Quick Sort

- R -

Range Conditions

IconConditions
IconRange Conditions

RATADIE_TO_DATE

IconDATE_TO_RATADIE
IconRATADIE_TO_DATE

RATIO_TO_REPORT

RATIO_TO_REPORT function: parameter must be a column

RDBMS

REAL

REAL 

IconSADAS Supported Datatypes
IconNumeric datatypes
IconNumeric Values

REBUILD

IconREBUILD DATABASE
IconREBUILD TABLE

REBUILD DATABASE

REBUILD TABLE

REFERENCES

IconSQL DDL Clauses (constraint)
IconALTER TABLE
IconALTER VIEW

REGEXP_INSTR

IconINSTR
IconREGEXP_INSTR

REGEXP_REPLACE

IconREGEXP_REPLACE
IconREPLACE

REGEXP_SUBSTR

IconREGEXP_SUBSTR
IconSUBSTR[ING]

Relational

Relational Databases

relational properties

relational table

RELOAD

RELOAD TABLE

REMAINDER

IconMOD
IconREMAINDER

RENAME

IconRENAME COLUMN
IconRENAME DATABASE
IconRENAME DOMAIN
IconRENAME TABLE
IconRENAME VIEW

RENAME COLUMN

RENAME DATABASE

IconRENAME DATABASE
IconCompendium of Sadas SQL Syntax

RENAME DOMAIN

RENAME TABLE

IconRENAME TABLE
IconCompendium of Sadas SQL Syntax

RENAME VIEW

IconRENAME VIEW
IconCompendium of Sadas SQL Syntax

REPLACE

IconCharacter Functions Returning Character Values
IconREGEXP_REPLACE
IconREPLACE
IconCREATE VIEW
IconCompendium of Sadas SQL Syntax

REPLICATE

IconREPLICATE
IconREPLICATE DATABASE
IconREPLICATE TABLE

REPLICATE DATABASE

IconREPLICATE DATABASE
IconCompendium of Sadas SQL Syntax

REPLICATE TABLE

IconREPLICATE TABLE
IconCompendium of Sadas SQL Syntax

Required Keywords

REVERSE

REVOKE

IconData Definition Language (DDL) Statements
IconREVOKE

REVOKE ALL

IconREVOKE
IconREVOKE FROM ROLE
IconCompendium of Sadas SQL Syntax

REVOKE TO ROLE

REWRITE

REWRITE DATABASE

REWRITE TABLE

RIGHT

RIGHT JOIN

RIGHT OUTER JOIN

RIGHTNULL

ROLE

IconCREATE ROLE
IconDROP ROLE
IconGRANT TO ROLE
IconREVOKE FROM ROLE

Role already exists

Role does not exist

Roles

ROMANIAN

Root of a negative number

ROUND

IconNumeric Functions
IconROUND
IconSDS-0129 "TRUNC/ROUND: exceeded the limit of decimals"

ROWID

IconPseudocolumns
IconROWID Pseudocolumn
IconROWNUM Pseudocolumn

ROWID Pseudocolumn

IconPseudocolumns
IconROWID Pseudocolumn
IconROWNUM Pseudocolumn

ROWNUM

ROWNUM Pseudocolumn

RPAD

IconCharacter Functions Returning Character Values
IconRPAD

RTRIM

IconCharacter Functions Returning Character Values
IconRTRIM

RULE

IconNumeric Values
IconDatetime Values

Rules

- S -

SADAS

Sadas Call Interface

Sadas Console

Sadas Database Control Manager

Sadas Package

Sadas Web

Scalar Subquery

IconUsing Subqueries
IconUnnesting of Nested Subqueries

Scalar Subquery Expressions

IconExpressions
IconAbout SQL Expressions
IconScalar Subquery Expressions

Scalar sub-query must return an unique value

SCHEMA

IconSchema/Database Objects
IconJoin Conditions
IconCREATE SEGMENT
IconCREATE SNAPSHOT
IconCREATE SYNONYM
IconCREATE TABLE
IconDELETE KEYS
IconIMPORT TABLE

SCI

SCL

SDS_HASH

IconSDS_HASH
IconSDS_HASH_SH1

SDS_HASH_Sh1

SECOND

IconDatetime datatypes
IconDatetime Values

SEGMENT

Segment already exists

Segment does not exist

SELECT

IconAbout SQL Expressions
IconAbout Queries and Subqueries
IconThe UNION [ALL], INTERSECT, MINUS Operators
IconData Manipulation Language (DML) Statements
IconINTERSECT
IconMINUS
IconSELECT
IconCompendium of Sadas SQL Syntax
IconSDS-0126 "Cannot nest more group functions"
IconSDS-0127 "In DUAL SELECT the following clause is not allowed"

select statement

Self Joins

IconSelf Joins
IconSpecial notes

Selfjoins

Semijoins

SET

IconSET LANGUAGE
IconSET VARIABLE
IconUNSET VARIABLE
IconUPDATE
IconCompendium of Sadas SQL Syntax

Set Operators

SHADOW

IconDESCRIBE TABLE
IconCompendium of Sadas SQL Syntax
IconGraphic Syntax Diagrams

SHUFFLE

SIGN

IconNumeric Functions
IconSIGN

Simple Expressions

IconExpressions
IconAbout SQL Expressions
IconSimple Expressions

SIN

Single-Row

IconSingle-Row Functions
IconNumeric Functions
IconCharacter Functions Returning Character Values
IconCharacter Functions Returning Numeric Values (COPY)
IconDatetime Functions
IconGeneral Comparison Functions
IconConversion Functions
IconEncoding and Decoding Functions

Single-Row Functions

IconSingle-Row Functions
IconNumeric Functions
IconCharacter Functions Returning Character Values
IconCharacter Functions Returning Numeric Values (COPY)
IconDatetime Functions
IconGeneral Comparison Functions
IconConversion Functions
IconEncoding and Decoding Functions

SINH

IconSINH
IconUPDATE COLUMNS

SKIP

IconAPPEND TABLE
IconINSERT TABLE
IconLOAD TABLE
IconREWRITE TABLE
IconUNLOAD TABLE

SMALLINT

IconSADAS Supported Datatypes
IconNumeric datatypes
IconNumeric Values

SNAPSHOT

IconADD SEGMENTOBJ
IconADD SNAPSHOTOBJ
IconCOMMENT ON SEGMENT
IconCOMMENT ON SNAPSHOT
IconCREATE SEGMENT
IconCREATE SNAPSHOT
IconDESCRIBE SEGMENT
IconDESCRIBE SNAPSHOT
IconDROP SNAPSHOT
IconDROP SEGMENTOBJ
IconDROP SNAPSHOTOBJ
IconMOUNT SNAPSHOT
IconUNMOUNT SNAPSHOT

Snapshot already exists

Snapshot does not exist

SNAPSHOTOBJ

IconADD SEGMENTOBJ
IconADD SNAPSHOTOBJ
IconCOMMENT ON SEGMENTOBJ
IconCOMMENT ON SNAPSHOTOBJ
IconDROP SEGMENTOBJ
IconDROP SNAPSHOTOBJ

Snow Flake schema

IconJoin Conditions
IconSDS-0119 "Join graph not supported"

SOUNDEX

IconCharacter Functions Returning Character Values
IconSOUNDEX

SPACE

SQL

IconIntroduction to SADAS SQL
IconHistory of SQL
IconSQL Standards
IconHow SQL Works
IconLexical Conventions

SQL Errors

SQL Functions

IconSQL Functions
IconAbout SQL Functions

SQL Operator Precedence

SQL Operators

SQL Standards

SQRT

IconNumeric Functions
IconSQRT

Sructured Query Language

IconIntroduction to SADAS SQL
IconHistory of SQL

STAR JOIN

IconJoin Conditions
IconSELECT

STAR operand not supported in this context

Star schema

IconJoin Conditions
IconSDS-0119 "Join graph not supported"

STDDEV

IconAggregate Functions
IconSTDDEV
IconSDS-0126 "Cannot nest more group functions"

storage path

IconCREATE DATABASE
IconDUPLICATE DATABASE
IconREPLICATE DATABASE

STORED

IconDELETE STORED QUERIES
IconDESCRIBE STORED QUERIES
IconEXECUTE STORED QUERIES

STORED QUERIES

IconDESCRIBE STORED QUERIES
IconCompendium of Sadas SQL Syntax

STRTOHEX

SUBQUERY

IconSimple Comparison Conditions
IconEXISTS Condition
IconIN Condition
IconSQL Queries and Subqueries
IconAbout Queries and Subqueries
IconThe UNION [ALL], INTERSECT, MINUS Operators
IconUsing Subqueries
IconSELECT
IconSDS-0123 "Column not found in the sub-query of the FROM clause"
IconGraphic Syntax Diagrams

SUBSTITUTE_WITH

SUBSTR

IconCharacter Functions Returning Character Values
IconREGEXP_SUBSTR
IconSUBSTR[ING]

SUBSTR function accepts only not negative integer parameters

SUBSTRING

IconREGEXP_SUBSTR
IconSUBSTR[ING]

SUM

IconAggregate Functions
IconSUM
IconSDS-0126 "Cannot nest more group functions"

SYNCHRONIZE

SYNCHRONIZE ALL

SYNONYM

IconCREATE SYNONYM
IconDROP SYNONYM

Syntax

IconSyntax Loops
IconBackus-Naur Form Syntax

Syntax error

Syntax Loops

Syntax Parameters

SYSALLCOLUMNS

SYSDATE

IconDatetime Functions
IconCURDATE
IconSYSDATE

SYSDB

IconDESCRIBE SYSDB
IconCompendium of Sadas SQL Syntax

SYSDBA

SYSDOMAINS

IconDESCRIBE SYSDOMAINS
IconCompendium of Sadas SQL Syntax

SYSFOREIGNKEYS

IconDESCRIBE SYSFOREIGNKEYS
IconCompendium of Sadas SQL Syntax

SYSKEYS

IconDESCRIBE SYSKEYS
IconCompendium of Sadas SQL Syntax

SYSLOG

IconDESCRIBE SYSLOG
IconCompendium of Sadas SQL Syntax

SYSOBJECTS

IconDESCRIBE SYSOBJECTS
IconCompendium of Sadas SQL Syntax

SYSROLES

SYSSNAPSHOTOBJS

IconDESCRIBE SYSSEGMENTOBJS
IconDESCRIBE SYSSNAPSHOTOBJS

SYSSYNONYMS

IconDESCRIBE SYSSEGMENTS
IconDESCRIBE SYSSNAPSHOTS
IconDESCRIBE SYSSYNONYMS

SYSTABLES

IconDESCRIBE SYSTABLES
IconCompendium of Sadas SQL Syntax

SYSTIME

IconDatetime Functions
IconCURTIME
IconSYSTIME

SYSTIMESTAMP

IconDatetime Functions
IconLOCALTIMESTAMP
IconNOW
IconSYSTIMESTAMP

SYSUSERS

IconDESCRIBE SYSUSERS
IconCompendium of Sadas SQL Syntax

SYSVIEWS

IconDESCRIBE SYSVIEWS
IconCompendium of Sadas SQL Syntax

- T -

TABLE

IconUsing Subqueries
IconCOMMENT ON COLUMN
IconCOMMENT ON TABLE
IconCREATE TABLE
IconDEACTIVATE DATABASE
IconDEACTIVATE TABLE
IconDESCRIBE TABLE
IconDROP TABLE
IconDUPLICATE TABLE
IconIMPORT TABLE
IconLOCK TABLE
IconREBUILD TABLE
IconRELOAD TABLE
IconRENAME TABLE
IconREPLICATE TABLE
IconSELECT
IconTRUNCATE TABLE
IconUNLOCK TABLE
IconUPDATE TABLE
IconSDS-0140 "Table locked"
IconGraphic Syntax Diagrams

Table has not a PRIMARY KEY

Table ID already exists

Table ID is wrong (<> 10 characters)

Table locked

TABLE NAME

IconCREATE TABLE
IconIMPORT TABLE

Table reference

Table/view already exists

Table/view auto-reference thru FOREIGN KEY

Table/view does not exist

Tables

TAN

TANH

Text literal too long

text Literals

The comparison value for the coded field is too long

The user already exist

The user does not exist

THEN

TIME

IconSADAS Supported Datatypes
IconDatetime datatypes
IconTIME Datatype
IconDatetime Values
IconDatetime Literals
IconDatetime Functions
IconNull Conditions
IconEXECUTE STORED QUERIES

TIMES

TIMESTAMP

IconSADAS Supported Datatypes
IconDatetime datatypes
IconTIMESTAMP Datatype
IconDatetime Values
IconDatetime Literals
IconDatetime Functions
IconNull Conditions

TO

IconDUPLICATE DATABASE
IconDUPLICATE TABLE
IconDUPLICATE USER
IconGRANT
IconGRANT TO ROLE
IconRENAME COLUMN
IconRENAME DATABASE
IconRENAME DOMAIN
IconRENAME TABLE
IconRENAME VIEW

TO_BASE

TO_CHAR function: erroneous NLS description

TO_CHAR function: invalid numeric format model

TO_CHAR function: second and third parameter must be string  constants

TO_CHAR(character)

IconConversion Functions
IconTO_CHAR (character)

TO_CHAR(datetime)

IconDatetime Functions
IconConversion Functions
IconTO_CHAR (datetime)

TO_CHAR(number)

IconConversion Functions
IconTO_CHAR (number)

TO_CODE

TO_DATE

IconDatetime Literals
IconDatetime Functions
IconConversion Functions
IconTO_DATE

TO_DESC

TO_NUMBER

TO_NUMBER function: unable to convert the string

TO_TIME

IconDatetime Literals
IconDatetime Functions
IconConversion Functions
IconTO_TIME

TO_TIMESTAMP

IconDatetime Literals
IconDatetime Functions
IconConversion Functions
IconTO_TIMESTAMP

TODAY

IconDatetime Functions
IconTODAY

Too many DISTINCT clauses

Too many DISTRIBUTE column ranges

Too many DISTRIBUTE ranges

Too many elements in update list

Too much tables in DELETE statement

TRANSLATE

IconCharacter Functions Returning Character Values
IconTRANSLATE

TRIM

IconCharacter Functions Returning Character Values
IconTRIM

TRUNC

IconNumeric Functions
IconTRUNC[ATE] (number)
IconSDS-0129 "TRUNC/ROUND: exceeded the limit of decimals"

TRUNC(number)

TRUNC/ROUND: exceeded the limit of decimals

TRUNCATE

IconNumeric Functions
IconTRUNC[ATE] (number)
IconData Definition Language (DDL) Statements
IconTRUNCATE DATABASE
IconTRUNCATE TABLE

TRUNCATE DATABASE

IconTRUNCATE DATABASE
IconCompendium of Sadas SQL Syntax

TRUNCATE TABLE

IconTRUNCATE TABLE
IconCompendium of Sadas SQL Syntax

Type mismatch for FOREIGN KEY

- U -

UCASE

IconUCASE
IconUPPER

Unary

Unary Operators

UNION

IconSet Operators
IconAbout Queries and Subqueries
IconThe UNION [ALL], INTERSECT, MINUS Operators
IconSELECT
IconUNION
IconCompendium of Sadas SQL Syntax

UNION ALL

IconSet Operators
IconAbout Queries and Subqueries
IconThe UNION [ALL], INTERSECT, MINUS Operators
IconUNION
IconCompendium of Sadas SQL Syntax

Unknown character

Unknown column name

Unknown table/view name

UNLOAD

UNLOAD DATABASE

UNLOAD TABLE

Unloaded table

UNLOCK

IconUNLOCK USER
IconUNLOCK TABLE
IconSDS-0140 "Table locked"

UNLOCK TABLE

UNLOCK USER

UNSET

IconSET VARIABLE
IconUNSET VARIABLE

Unsupported function/operation

UPDATE

IconData Manipulation Language (DML) Statements
IconUPDATE
IconUPDATE COLUMNS
IconUPDATE TABLE
IconCompendium of Sadas SQL Syntax
IconSDS-0128 "UPDATE: group functions are not allowed on right part"

UPDATE COLUMN

IconUPDATE COLUMNS
IconCompendium of Sadas SQL Syntax

UPDATE not allowed on column ROWID

UPDATE not allowed on primary key

UPDATE TABLE

IconUPDATE TABLE
IconCompendium of Sadas SQL Syntax

UPDATE: group functions are not allowed on right part

UPPER

IconCharacter Functions Returning Character Values
IconUCASE
IconUPPER

USER

IconALTER USER
IconCONNECT
IconCREATE DBADMIN
IconCREATE USER
IconDESCRIBE USER
IconDROP USER
IconDUPLICATE USER
IconLOCK USER
IconUNLOCK USER
IconCompendium of Sadas SQL Syntax

User domain does not exist

User has no rights to execute this command

Users

- V -

VALUES

VARCHAR

IconSADAS Supported Datatypes
IconCharacter datatypes
IconCharacter Values
IconBinary Comparisons
IconBlank-Padded Comparison Semantics
IconCharacter Functions Returning Character Values

VARIABLE

IconSET VARIABLE
IconUNSET VARIABLE

VARIANCE

IconAggregate Functions
IconVARIANCE
IconSDS-0126 "Cannot nest more group functions"

VIEW

IconUsing Subqueries
IconALTER VIEW
IconCREATE VIEW
IconDROP VIEW
IconRENAME VIEW
IconSELECT
IconSDS-0125 "Not supported syntax for CREATE VIEW statement"
IconGraphic Syntax Diagrams

view name

Views

VIRTUAL

IconSQL DDL Clauses (constraint)
IconVirtual Constraints

Virtual Constraints

VSIZE

IconIS_FIRST
IconVSIZE

VSIZE function: parameter must be a column

- W -

WHEN

WHERE

IconDELETE TABLE
IconSELECT
IconUPDATE
IconCompendium of Sadas SQL Syntax
IconSDS-0127 "In DUAL SELECT the following clause is not allowed"

WHERE CLAUSE

IconAbout SQL Expressions
IconExpression Lists
IconAbout SQL Conditions
IconCondition Precedence
IconComparison Conditions
IconSimple Comparison Conditions
IconLogical Conditions
IconIN Condition
IconAbout Queries and Subqueries
IconUsing Subqueries

Wrong date

Wrong DISTRIBUTE parameter

Wrong DISTRIBUTE parameter configuration

Wrong hidden condition

Wrong number of columns in the sub-query of the FROM clause

Wrong number of parameters

Wrong time

Wrong timestamp

Wrong use of function DATEADD

Wrong use of function DATEDIFF

Wrong use of function DATEPART

Wrong use of function NEXT_DAY

Wrong use of function PREVIOUS_DAY

Wrong use of function SUBSTITUTE_WITH

Wrong use of function TO_DATE

Wrong use of function TO_TIME

Wrong use of function TO_TIMESTAMP

- Y -

YEAR

IconDatetime datatypes
IconDatetime Values