aboutsummaryrefslogtreecommitdiff
path: root/vim/bundle/vim-snippets/snippets/plsql.snippets
diff options
context:
space:
mode:
Diffstat (limited to 'vim/bundle/vim-snippets/snippets/plsql.snippets')
-rw-r--r--vim/bundle/vim-snippets/snippets/plsql.snippets109
1 files changed, 109 insertions, 0 deletions
diff --git a/vim/bundle/vim-snippets/snippets/plsql.snippets b/vim/bundle/vim-snippets/snippets/plsql.snippets
new file mode 100644
index 0000000..2920758
--- /dev/null
+++ b/vim/bundle/vim-snippets/snippets/plsql.snippets
@@ -0,0 +1,109 @@
+# create package spec
+snippet ps
+ create or replace package ${1:name}
+ as
+ ${0:-- spec}
+ end; -- end of package spec $1
+# create package body
+snippet pb
+ create or replace package body ${1:name}
+ as
+ ${0:-- body}
+ end; -- end of package body $1;
+# package procedure spec
+snippet pps
+ procedure ${1:name}(${0:args});
+# package procedure body
+snippet ppb
+ procedure ${1:name}(${2:args})
+ as
+ begin
+ ${0:-- body}
+ end $2;
+# package function spec
+snippet pfs
+ function ${1:name}(${2:args})
+ return ${0:type};
+# package function body
+snippet pfb
+ function ${1:name}(${2:args})
+ return ${3:type}
+ as
+ l_res $3;
+ begin
+ ${0:-- body};
+ return l_res;
+ end $1;
+# snow errors
+snippet err
+ show errors;
+# proc/func in parameter
+snippet p
+ ${1:name} ${2:in} ${3:type} ${0: := null}
+# package type: record
+snippet tr
+ type tr_${1:name} is record (${0:/* columns */});
+# package type: nested table
+snippet tt
+ type tt_${1:name} is table of tr_${0:name};
+# package type: indexed table
+snippet tti
+ type tt_${1:name} is table of tr_${0:name} index by binary_integer;
+# proc/func comment
+snippet doc
+ /*
+ * ${0: comment ...}
+ */
+# plsql block
+snippet beg
+ begin
+ ${0}
+ end;
+# plsql block with declare part
+snippet dec
+ declare
+ ${1}
+ begin
+ ${0}
+ end;
+# return pipe row
+snippet rpipe
+ for ${1:i} in 1 .. ${0:l_res}.count loop
+ pipe row( $2($1) );
+ end loop;
+ return;
+# bulk collect
+snippet bc
+ bulk collect into ${0}
+# local variable
+snippet l
+ l_${1} ${0:number};
+# output
+snippet log
+ dbms_output.put_line('${0}');
+# for loop
+snippet for
+ for ${1:i} in ${2:1}..${3:42} loop
+ ${0}
+ end loop;
+# for loop with select
+snippet fors
+ for ${1:rec} in (${2: select}) loop
+ ${0}
+ end loop;
+# for loop with collection
+snippet forc
+ for ${1:i} in ${2:l_var}.first .. $2.last loop
+ ${0: -- dbms_output.put_line($2($1)); }
+ end loop;
+# if
+snippet if
+ if ${1} then
+ ${0}
+ end if;
+snippet ife
+ if ${1} then
+ ${2}
+ else
+ ${0}
+ end if;