Function SQL-OPERATOR — Returns the symbol for the supplied SQL operator.
Function
sql-operator operation => result
A symbol denoting an SQL operator.
The Lisp symbol used by CLSQL to represent the specified operator.
Returns the Lisp symbol corresponding to the SQL operation represented by the symbol operation. If operation does not represent a supported SQL operator or is not a symbol, nil is returned.
(sql-operator 'like) => SQL-LIKE
None.
None.
None.
sql |
sql-expression |
sql-operation |
CLSQL's symbolic SQL syntax currently has support for the following SQL operators:
any |
some |
all |
not |
union |
intersect |
minus |
except |
order-by |
null |
* |
+ |
/ |
- |
like |
and |
or |
in |
substr |
|| |
= |
< |
> |
>= |
<= |
<> |
count |
max |
min |
avg |
sum |
function |
between |
distinct |
nvl |
slot-value |
userenv |
concat |
substring |
limit |
group-by |
having |
not-null |
exists |
uplike |
is |
== |
the |
coalesce |
view-class |
as well as the pseudo-operator function. Note that some of these operators are not supported by all of the RDBMS supported by CLSQL.