oracle.vim : Oracle SQL*Plus IDE
| script karma
Downloaded by 4022
Comments, bugs, improvements
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
<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
<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
<Leader>s Execute current selection in SQL*Plus and get the result to a
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
sql.vim - sql filetype plugin load to your ftplugin folders. This file is
needed for Abbreviations and some mappings
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.
If the above links don't work try this one.
|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
Rating scripts is only available on the
script versions (upload new version)
Click on the package to download.
ip used for rating: 18.104.22.168
- 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)
||Added DescribeObject function to fix the Ctrl+D mapping issue in sql.vim ftplugin
||Changed the error highlighting method to use +signs if available