sponsor Vim development Vim logo Vim Book Ad

oracle.vim : Oracle SQL*Plus IDE

 script karma  Rating 45/21, Downloaded by 3637    Comments, bugs, improvements  Vim wiki

created by
Rajesh Kallingal
 
script type
utility
 
description
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
 
install details
Just drop it this file in your plugin folder/directory.

If you are downloading 6.0.3 or prior version, to get some of the additional features you have to download the ftplugin sql.vim (http://vim.sourceforge.net/scripts/script.php?script_id=142) and put that
in the ftplugin folder/directory. This script is included in the zip file from 6.0.4 onwards
 

rate this script Life Changing Helpful Unfulfilling 
script versions (upload new version)

Click on the package to download.

package script version date Vim version user release notes
oracle.zip 6.0.4 2002-02-05 6.0 Rajesh Kallingal Changes:
- Added online help (oracle.txt)
- Save and retrieve connection info between sessions
- created new function GetColumn() to handle inserting column names for the table.
- redefined most of the connection variables.

Now its a zip file with online document as well as the ftplugin sql.vim (script# 141)
oracle.vim 6.0.3 2002-01-11 6.0 Rajesh Kallingal Added DescribeObject function to fix the Ctrl+D mapping issue in sql.vim ftplugin
oracle.vim 6.0.2 2001-11-26 6.0 Rajesh Kallingal Changed the error highlighting method to use +signs if available
oracle.vim 6.0.1 2001-11-11 6.0 Rajesh Kallingal Initial upload
ip used for rating: 54.196.189.229

If you have questions or remarks about this site, visit the vimonline development pages. Please use this site responsibly.
Questions about Vim should go to the maillist. Help Bram help Uganda.
   
SourceForge.net Logo