Re: silly vi question
- From: Egor Starostin <egorst@xxxxxxxxx>
- To: bobmetelsky@xxxxxxxxxxx
- Date: Fri, 12 Nov 2004 13:47:29 +0600
> does anyone use syntax highlighting for vi or vim? Id like to at least
> get .oracle- .sql and possible shell scripts. The black and white gets
> my eyes crossed in a few hours ;-) The syntax highlighting would be a
> god send!
>
> I googled for it but nothing is prominent, so I thought asking here
> would be more efficient than trying all sorts of things that dont work.
Here's the steps which I did to allow to use vim in sqlplus (with
syntax highlighting and words completion):
1. add 'define _editor=vim' to ~/login.sql
2. add to ~/.vimrc
***
set nocompatible
syntax on
" next function allows you to do completion of words by pressing <Tab>
function! InsertTabWrapper?(direction)
let col = col('.') - 1
if !col || getline('.')[col - 1] !~ '\k'
return "\<tab>"
elseif "backward" == a:direction
return "\<c-p>"
else
return "\<c-n>"
endif
endfunction
inoremap <tab> <c-r>=InsertTabWrapper? ("forward")<cr>
inoremap <s-tab> <c-r>=InsertTabWrapper? ("backward")<cr>
***
3. add to ~/.vim/after/ (create this dir if necessary) file
filetype.vim with content:
***
augroup filetypedetect
au BufNewFile,BufRead afiedt.buf setf sql
augroup END
***
4. add to ~/.vim/after/syntax/ file sql.vim with content:
***
set dict+=$HOME/.vim/dict/sql.dict " our own dictionary
set cpt=.,k,w,b,t,i " use keywords (k) for completion
***
5. this step is optional. create file ~/.vim/dict/sql.dict with words
for which you'd like to use completion (note, that completion will
already work for standard keywords defined in
$VIMRUNTIME/syntax/sql.vim). It may be words like dual,dba_segments
etc.
If you want to use vim alone (not as an editor in sqlplus) then just
skip first and third steps.
Egor
http://www.oracledba.ru/orasrp/
Free Oracle Session Resource Profiler
--
//www.freelists.org/webpage/oracle-l
Other related posts:
