sa_statement_text system procedure

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

Result set

Column name	Data type	Description
stmt_text	LONG VARCHAR	A clause of the SELECT statement.

Remarks

Privileges

Side effects

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''' );

	stmt_text
1	SELECT *
2	FROM car
3	WHERE name = 'Audi'

Discuter à propos de cette page dans DocCommentXchange.