Toad supports the following expressions:
|
Expression |
Description |
Examples |
|---|---|---|
|
Literal |
Represents a literal string value. Literal string values are enclosed with beginning and ending single quote ( ’r;’ ) characters. If you need to create a literal string that includes a single quote in it, enter two single quotes ( ’’ ) where you need the actual quote and then close the string with a single quote ( ’ ). |
’r;Hello there’ ’r;Don’’t’ |
|
Number |
Uses a floating point number format. |
1.23E-5 .8 10.2 5123 |
|
Operator |
Uses any supported operator. See Supported Operators for more information. |
+ . and |
|
Identifier |
Includes any expression that does not fit in the other expression categories. When using a ”r; or ` character, an identifier can be quoted to any string. |
@variable ”r;A long identifier” |
© ALL RIGHTS RESERVED. Terms of Use Privacy Cookie Preference Center
