sql.snippets 794 B

1234567891011121314151617181920212223242526
  1. snippet tbl
  2. create table ${1:table} (
  3. ${2:columns}
  4. );
  5. snippet col
  6. ${1:name} ${2:type} ${3:default ''} ${4:not null}
  7. snippet ccol
  8. ${1:name} varchar2(${2:size}) ${3:default ''} ${4:not null}
  9. snippet ncol
  10. ${1:name} number ${3:default 0} ${4:not null}
  11. snippet dcol
  12. ${1:name} date ${3:default sysdate} ${4:not null}
  13. snippet ind
  14. create index ${3:$1_$2} on ${1:table}(${2:column});
  15. snippet uind
  16. create unique index ${1:name} on ${2:table}(${3:column});
  17. snippet tblcom
  18. comment on table ${1:table} is '${2:comment}';
  19. snippet colcom
  20. comment on column ${1:table}.${2:column} is '${3:comment}';
  21. snippet addcol
  22. alter table ${1:table} add (${2:column} ${3:type});
  23. snippet seq
  24. create sequence ${1:name} start with ${2:1} increment by ${3:1} minvalue ${4:1};
  25. snippet s*
  26. select * from ${1:table}