VALIDATE_SQL

This function, along with COMPLETE_SQL, VALIDATE_SQL and FORMAT_SQL is primarily used for tool developers (s-Studio uses these functions to complete, validate, and format SQL). Validates SQL statement.

Syntax

SYS_BOOT.MGMT.VALIDATE_SQL(sql_statement,default_schema);

Returns table | Field | Type | | — | — | | start_line_num | integer| | end_line_num | integer| | message | varchar(4096)