SQLPlus
Sublime Text 3 plugin for Oracle Database SQL*Plus.
Details
Installs
- Total 11K
- Win 8K
- Mac 2K
- Linux 1K
Mar 15 | Mar 14 | Mar 13 | Mar 12 | Mar 11 | Mar 10 | Mar 9 | Mar 8 | Mar 7 | Mar 6 | Mar 5 | Mar 4 | Mar 3 | Mar 2 | Mar 1 | Feb 28 | Feb 27 | Feb 26 | Feb 25 | Feb 24 | Feb 23 | Feb 22 | Feb 21 | Feb 20 | Feb 19 | Feb 18 | Feb 17 | Feb 16 | Feb 15 | Feb 14 | Feb 13 | Feb 12 | Feb 11 | Feb 10 | Feb 9 | Feb 8 | Feb 7 | Feb 6 | Feb 5 | Feb 4 | Feb 3 | Feb 2 | Feb 1 | Jan 31 | Jan 30 | |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
Windows | 0 | 1 | 0 | 0 | 0 | 1 | 0 | 1 | 1 | 2 | 2 | 2 | 1 | 0 | 2 | 0 | 1 | 1 | 1 | 1 | 0 | 0 | 0 | 0 | 1 | 1 | 0 | 0 | 3 | 1 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 2 | 0 | 0 |
Mac | 0 | 0 | 0 | 1 | 0 | 1 | 0 | 0 | 0 | 2 | 0 | 0 | 0 | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 1 | 0 |
Linux | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 |
Readme
- Source
- raw.githubusercontent.com
STATUS: UNSUPPORTED
I stopped working with Oracle Database and unfortunately do not have time to support this project.
SQL*Plus plugin for Sublime Text 3
Ever been annoyed by Oracle SQL*Plus’s lack of text editing features? Love Sublime Text? This plugin is for you.
Features
- Both input and output are selectable and editable.
- Commands history.
- Auto-completion of script filenames in workdir.
- Syntax highlighting for SQL and PL/SQL included.
- One tab - one SQL*Plus subprocess. Auto-termination on tab close.
- Do whatever you would do in SQL*Plus without leaving Sublime Text window.
Installation
- With Package Control: Run
Package Control: Install Package
command, find and installSQLPlus
plugin. - Manual: Clone this repo to your Packages folder.
- Edit
SQLPlus.sublime-settings
and set path to your SQL*Plus executeable and working directory. - (Optional) In a new tab in Sublime Text type
prompt Hello World!
and hitCtrl+F8
How it works?
This plugin redirects input and output between Sublime Text and SQL*Plus.
Settings
"connection_string": "##Sublime{|}##"
- this is not the database connection string. DO NOT put your database credentials there. This string is used in a hack to print current connection in the ST status bar. To make it work your SQL*Plus must print the current connection details. With the default setting it should work if you putprompt ##Sublime{&_USER@&_CONNECT_IDENTIFIER}##
to your login.sql.
Usage
Ctrl+F8
- execute the selected text or current line (if nothing selected) in SQL*Plus. In case of multiple selections only the first selection is sent to SQL*Plus.Alt+Up
- replace selection with previous command in historyAlt+Down
- replace selection with next command in history
Problems
- Tested only on Windows