...
Attributes
| Name | Description | Example | |
|---|---|---|---|
| SQL_ISNULL | If the field is null then it replaces its value. | SQL_ | UPPERISNULL(FieldA, '') |
SQL_UPPER | Converts lowercase letters to uppercase. | SQL_UPPER(CC.CONTACTFIRSTNAME) | |
| SQL_+ | String concatenation. | ||
| SQL_GETDATETIME | Used to retrieve the current timestamp. | ||
SQL_TOCHAR | Converts a field to a value of VARCHAR2 datatype. | ||
| SQL_SUBSTRING | Retrieves the substring of a string. | ||
| SQL_CONCAT | Concatenates a number of fields. | SQL_CONTCAT[FieldA~FieldB~…~FieldN] | |
| SQL_YEAR[ ]SQL_YEAR | Get the year of a date. | ||
| SQL_MONTH[ ]SQL_MONTH | Get the month of a date. | ||
| SQL_WEEK[ ]SQL_WEEK | Get the week of a date. | ||
| SQL_DAY[ ]SQL_DAY | Get the day of a date. | ||
| SQL_NUMERAL SQL_NUMERAL | Gets the number of days of a date |
...
Examples
| Expand | |||||||||
|---|---|---|---|---|---|---|---|---|---|
| |||||||||
|
...
| title | SQL_CONCAT |
|---|
...
| theme | Eclipse |
|---|---|
| language | xml |
| title | SQL_CONCAT |
...