SQL Syntax Extension Preferences


On two tabbed pages you can configure a part of the SQL syntax, namely datatypes and functions. Any changes you apply here will affect the syntax error recognition in the SQL editor and Instant SQL view as well as the SQL content assist of these parts.
For any entry you must specify at least a name which cannot be the same as an already existing name. Optionally you can specify datatype creation arguments or function arguments respectively. This has to be done using a specific syntax:
Example:
Consider the datatype definition numeric [(<int>[, <int>])]
This means that a new datatype numeric is inserted into the the syntax definition which can be used either with one or with two comma-separated integer arguments in braces or it can be used without any argument. When used in a SQL text you later may type in an editor, this would look like:
numeric(10),
numeric(10,10) or
numeric

The  shorthand exp means that the argument can be a valid SQL row value expression .


By default there are the following datatypes and functions configured:

Name

Arguments

Datatypes

SQL typebit
SQL typeblob (<int>[k|m|g])
SQL typechar [(<int>)]
SQL typecharacter [(<int>)]
SQL typeclob (<int>[k|m|g])
SQL typedate

SQL typedec [(<int>[,<int>])]
SQL typedecimal [(<int>[,<int>])]
SQL typedouble precision
[(<int>)]
SQL typefloat

SQL typeint

SQL typeinteger

SQL typeinterval

SQL typenational char
[[varying] (<int>)]
SQL typenational character [[varying] (<int>)]
SQL typenchar
[[varying] (<int>)]
SQL typenumeric
[(<int>[,<int>])]
SQL typereal

SQL typesmallint

SQL typetime
[[(<int>)] with time zone]
SQL typetimestamp
[[(<int>)] with time zone]
SQL typevarchar
(<int>) [character set <String>]
SQL typevarchar2 (<int>) [character set <String>]


Functions

SQL typeavg
(<exp>)
SQL typecount
(<exp>)
SQL typemax
(<exp>)
SQL typemin
(<exp>)
SQL typesum
(<exp>)




Legal Notice