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)