The syntax examples use Oracle's typographic conventions for SQL code examples. The following table shows the conventions used in SQL syntax examples.
| Convention | Meaning | Example |
| [ ] | Anything enclosed in brackets is optional. | LTRIM(char [ , set ]) |
| { } | Braces are used for grouping items. | TO_CHAR({ datetime | interval } [, fmt [, 'nlsparam' ] ]) |
| | | A vertical bar represents a choice of two options. | ATAN2(n1 { , | / } n2) |
| ... | An ellipsis mean repetition in syntax descriptions or an omission in code examples or text. | DECODE(expr, search, result [, search, result ]...[, default ]) |
| UPPERCASE | Indicates an element supplied by the system. These terms are shown in uppercase to distinguish them from terms you define. Unless terms appear in brackets, enter them in the order and with the spelling shown. Because these terms are not case sensitive, you can use them in either UPPERCASE or lowercase. | TRIM([ { { LEADING | TRAILING | BOTH }[ trim_character ] | trim_character } FROM ] trim_source) |
| lowercase |
Indicates user-defined programmatic elements, such as field names. Note that some programmatic elements use a mixture of UPPERCASE and lowercase. Enter these elements as shown. |
NULLIF(expr1, expr2) |
The examples are provided for illustrative purposes only. They may or may not work for you, depending on your NetSuite account settings and data.