FORMAT_SQL

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

Syntax:

SYS_BOOT.MGMT.FORMAT_SQL(
sql_chunks cursor,
always_use_parentheses boolean,
case_clauses_on_new_lines boolean,
clause_starts_line boolean,
keywords_lowercase boolean,
quote_all_identifiers boolean,
select_list_items_on_separate_lines boolean,
where_list_items_on_separate_lines boolean,
window_declaration_starts_line boolean,
window_list_items_on_separate_lines boolean,
indentation integer,
line_length integer)
;

Returns table (chunk_idx,formatted_sql)