Formats a SELECT statement so that individual items appear on separate lines. This is useful when viewing long statements from the request log, in which all newline characters are removed.

Syntax

sa_statement_text( txt )

Arguments

Remarks

The txt that is entered must be a string (in single quotes) or a string expression.

Permissions

None

Side effects

None

See also

• sa_get_request_times system procedure
• sa_get_request_profile system procedure

Example

The following call formats a SELECT statement so that individual items appear on separate lines.

CALL sa_statement_text( 'SELECT * FROM car WHERE name=''Audi''' );