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/sql.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/sql.snippets')
-rw-r--r-- | vim/bundle/vim-snippets/snippets/sql.snippets | 26 |
1 files changed, 26 insertions, 0 deletions
diff --git a/vim/bundle/vim-snippets/snippets/sql.snippets b/vim/bundle/vim-snippets/snippets/sql.snippets new file mode 100644 index 0000000..556fae0 --- /dev/null +++ b/vim/bundle/vim-snippets/snippets/sql.snippets @@ -0,0 +1,26 @@ +snippet tbl + create table ${1:table} ( + ${0:columns} + ); +snippet col + ${1:name} ${2:type} ${3:default ''} ${0:not null} +snippet ccol + ${1:name} varchar2(${2:size}) ${3:default ''} ${0:not null} +snippet ncol + ${1:name} number ${3:default 0} ${0:not null} +snippet dcol + ${1:name} date ${3:default sysdate} ${0:not null} +snippet ind + create index ${0:$1_$2} on ${1:table}(${2:column}); +snippet uind + create unique index ${1:name} on ${2:table}(${0:column}); +snippet tblcom + comment on table ${1:table} is '${0:comment}'; +snippet colcom + comment on column ${1:table}.${2:column} is '${0:comment}'; +snippet addcol + alter table ${1:table} add (${2:column} ${0:type}); +snippet seq + create sequence ${1:name} start with ${2:1} increment by ${3:1} minvalue ${0:1}; +snippet s* + select * from ${0:table} |