FORMAT_SQL

<< Click to Display Table of Contents >>

Navigation:  Streaming SQL Reference Guide > Basic Building Blocks > Functions > Built-in Functions > General Management Functions >

FORMAT_SQL

Previous pageReturn to chapter overviewNext page

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).

5_2_indicator

Version 5.2 Feature

As of version 5.2, you no longer need to use the preface SYS_BOOT.MGMT.

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)