SQLPlus
Sublime Text 3 plugin for Oracle Database SQL*Plus.
Details
Installs
- Total 11K
- Win 9K
- Mac 2K
- Linux 1K
May 16 | May 15 | May 14 | May 13 | May 12 | May 11 | May 10 | May 9 | May 8 | May 7 | May 6 | May 5 | May 4 | May 3 | May 2 | May 1 | Apr 30 | Apr 29 | Apr 28 | Apr 27 | Apr 26 | Apr 25 | Apr 24 | Apr 23 | Apr 22 | Apr 21 | Apr 20 | Apr 19 | Apr 18 | Apr 17 | Apr 16 | Apr 15 | Apr 14 | Apr 13 | Apr 12 | Apr 11 | Apr 10 | Apr 9 | Apr 8 | Apr 7 | Apr 6 | Apr 5 | Apr 4 | Apr 3 | Apr 2 | Apr 1 | |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
Windows | 0 | 0 | 2 | 1 | 1 | 0 | 1 | 0 | 0 | 0 | 0 | 2 | 0 | 0 | 1 | 0 | 2 | 0 | 0 | 0 | 1 | 0 | 1 | 1 | 1 | 0 | 1 | 0 | 1 | 0 | 1 | 1 | 1 | 0 | 0 | 0 | 2 | 0 | 0 | 1 | 1 | 0 | 0 | 1 | 0 | 2 |
Mac | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 2 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 2 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 2 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 |
Linux | 0 | 1 | 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 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 |
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