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