📄 header.sql
字号:
create or replace PACKAGE PKG_GEN AS
g_version constant varchar2(200) := '1.0a';
type string_list is table of clob;
function get_version return varchar2;
function generate_merge_procedure(p_table_name in varchar2) return clob;
function generate_select_function(p_table_name in varchar2, p_order_by_columns in varchar2 default null) return clob;
function generate_delete_procedure(p_table_name in varchar2) return clob;
function generate_package(p_table_name in varchar2, p_package_name in varchar2) return clob;
function generate_package_body(p_table_name in varchar2, p_package_name in varchar2) return clob;
function get_procedure_params(
p_table_name in varchar2,
p_prefix in varchar2 default null,
p_postfix in varchar2 default null,
p_delimiter in varchar2 default ', ',
p_pk in integer default 0,
p_fk in integer default 0) return varchar2;
END PKG_GEN;
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -