Ⅰ. 插件描述
Oracle SQL*Plus IDEⅡ. 基本信息
|
Ⅲ. 安装方法
使用Vundle管理器安装
在你的.vimrc下添加:Plugin '/oracle-vim'
… 然后在Vim中运行以下命令:
:source %
:PluginInstall
对于Vundle版本 < 0.10.2,请用上面的Bundle替换Plugin。
使用NeoBundle管理器安装
在你的.vimrc下添加:NeoBundle '/oracle-vim'
… 然后在Vim中运行以下命令:
:source %
:NeoBundleInstall
使用VimPlug管理器安装
在你的.vimrc下添加:Plug '/oracle-vim'
… 然后在Vim中运行以下命令:
:source %
:PlugInstall
使用Pathogen管理器安装
在终端中运行以下命令:cd ~/.vim/bundle
git clone https://github.com/vim-scripts/oracle.vim
Ⅳ. 文档说明
Description:
This file contains functions/menus/commands/abbreviations to make Vim an
Oracle SQL*Plus IDE.
Here are the main highlights of this script:
SqlMake(): lets you open any stored procedure and compile from within vim.
Will display and optionally highlight the errors, navigate
thru errors in the quickfix mode.- Adds a SQL*Plus menu
- SqlPlus(): lets you start an external SQL*Plus, execute the whole file
contents in SQL*Plus and return the results back in the same
buffer, or select a portion of the buffer, execute it and
display the results in a new buffer. - GetSource(): get the stored procedure code from the database
- Abbreviations: lot of abbreviations to make coding in PL/SQL a breeze,
all accessible thru menu as well
Mappings:
<Leader>c Select Database dialog
<Leader>C Get column names for the tablename under cursor
<Leader>F Stored procedure code from DB for the function/procedure name
under cursor
<Leader>i Find Invalid Objects
CTRL+S Start SQL*Plus window (external)
<Leader>r Execute current file in SQL*Plus window (external)
<Leader>s Execute current file in SQL*Plus and get the result to same
buffer
<Leader>s Execute current selection in SQL*Plus and get the result to a
new window
Following mappings from ftplugin sql.vim
<C-D> Describe the object under cursor
<LocalLeader>d make a dbms_output.put_line statement for word/selection
below current line
<LocalLeader>D make a dbms_output.put_line statement for word/selection
above current line
Optional files:
sql.vim - sql filetype plugin load to your ftplugin folders. This file is
needed for Abbreviations and some mappings
Note:
I have tested this only under gvim6.0 on Win2000 and Oracle 8.1.5. I do
not have any other platform to test these.
Screen Shots:
http://www.geocities.com/rajesh_kallingal/vim/vimsql01.jpg
http://www.geocities.com/rajesh_kallingal/vim/vimsql02.jpg
If the above links don't work try this one.
http://www.geocities.com/rajesh_kallingal/vim