/usr/share/vim/addons/snippets/plsql.snippets is in vim-snippets 1.0.0-4.
This file is owned by root:root, with mode 0o644.
The actual contents of the file can be viewed below.
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 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;
|