diff options
Diffstat (limited to 'vim/bundle/vim-snippets/snippets/plsql.snippets')
m--------- | vim/bundle/vim-snippets | 0 | ||||
-rw-r--r-- | vim/bundle/vim-snippets/snippets/plsql.snippets | 109 |
2 files changed, 0 insertions, 109 deletions
diff --git a/vim/bundle/vim-snippets b/vim/bundle/vim-snippets new file mode 160000 +Subproject 15d7e5ec26ec93adee4051b6359be90a943aa38 diff --git a/vim/bundle/vim-snippets/snippets/plsql.snippets b/vim/bundle/vim-snippets/snippets/plsql.snippets deleted file mode 100644 index 2920758..0000000 --- a/vim/bundle/vim-snippets/snippets/plsql.snippets +++ /dev/null @@ -1,109 +0,0 @@ -# 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; |