ctrl+shift+p filters: :st2 :st3 :win :osx :linux
Browse

SQLPlus

by bofm ST3

Sublime Text 3 plugin for Oracle Database SQL*Plus.

Details

Installs

  • Total 11K
  • Win 8K
  • Mac 2K
  • Linux 1K
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 Mar 31 Mar 30 Mar 29 Mar 28 Mar 27 Mar 26
Windows 0 1 0 0 0 0 0 1 1 4 1 0 1 1 1 1 1 0 0 0 0 0 2 1 0 1 1 1 0 0 1 2 1 1 2 1 0 0 3 2 0 0 0 0 1 1
Mac 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1 0 0 0 0 0 0 0 2 0 1 0 0 0 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1 1
Linux 0 0 0 0 0 0 0 0 0 1 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 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 install SQLPlus 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 hit Ctrl+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 put prompt ##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 history
  • Alt+Down - replace selection with next command in history

Problems

  • Tested only on Windows