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