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