oracle.vim


Ⅰ. 插件描述

Oracle SQL*Plus IDE

Ⅱ. 基本信息

创建日期:  2001-11-11
使用用户:  1
Github星:  2
插件作者:  Rajesh Kallingal

Ⅲ. 安装方法

使用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

添加新评论