diff options
author | Karel Kočí <cynerd@email.cz> | 2016-06-30 16:03:25 +0200 |
---|---|---|
committer | Karel Kočí <cynerd@email.cz> | 2016-06-30 16:03:25 +0200 |
commit | e573b3020c032400eed60b649a2cbf55266e6bb0 (patch) | |
tree | 8f572394ac8433529c7a8e70d160a2fbe8268b4e /vim/bundle/vim-snippets/snippets/plsql.snippets | |
parent | b8c667bd64b3edd38d56c63c5bd1db53a23b4499 (diff) | |
download | myconfigs-e573b3020c032400eed60b649a2cbf55266e6bb0.tar.gz myconfigs-e573b3020c032400eed60b649a2cbf55266e6bb0.tar.bz2 myconfigs-e573b3020c032400eed60b649a2cbf55266e6bb0.zip |
Add current configurations from old repository
Diffstat (limited to 'vim/bundle/vim-snippets/snippets/plsql.snippets')
-rw-r--r-- | vim/bundle/vim-snippets/snippets/plsql.snippets | 109 |
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; |