procedure set_from

procedure set_from(
    p_query in out t_query,
    p_name in varchar2
)

set from list

procedure add_select

procedure add_select(
    p_query in out t_query,
    p_name in varchar2
)

add to select list

procedure add_from

procedure add_from(
    p_query in out t_query,
    p_name in varchar2
)

add to from list

procedure add_where

procedure add_where(
    p_query in out t_query,
    p_name in varchar2
)

add to where list

procedure add_group_by

procedure add_group_by(
    p_query in out t_query,
    p_name in varchar2
)

add to group by list

procedure add_order_by

procedure add_order_by(
    p_query in out t_query,
    p_name in varchar2
)

add to order by list

function get_sql

function get_sql(
    p_query in t_query,
    p_include_where in boolean:=true,
    p_include_group_by in boolean:=true,
    p_include_order_by in boolean:=true
) return varchar2

get SQL text

record t_query

type t_query is record(
    f_select string_util_pkg.t_max_pl_varchar2,
    f_from string_util_pkg.t_max_pl_varchar2,
    f_where string_util_pkg.t_max_pl_varchar2,
    f_group_by string_util_pkg.t_max_pl_varchar2,
    f_order_by string_util_pkg.t_max_pl_varchar2
)