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
Mar 15 Mar 14 Mar 13 Mar 12 Mar 11 Mar 10 Mar 9 Mar 8 Mar 7 Mar 6 Mar 5 Mar 4 Mar 3 Mar 2 Mar 1 Feb 28 Feb 27 Feb 26 Feb 25 Feb 24 Feb 23 Feb 22 Feb 21 Feb 20 Feb 19 Feb 18 Feb 17 Feb 16 Feb 15 Feb 14 Feb 13 Feb 12 Feb 11 Feb 10 Feb 9 Feb 8 Feb 7 Feb 6 Feb 5 Feb 4 Feb 3 Feb 2 Feb 1 Jan 31 Jan 30
Windows 0 1 0 0 0 1 0 1 1 2 2 2 1 0 2 0 1 1 1 1 0 0 0 0 1 1 0 0 3 1 0 0 0 1 0 0 0 1 0 0 0 0 2 0 0
Mac 0 0 0 1 0 1 0 0 0 2 0 0 0 0 0 1 1 0 0 0 0 0 0 0 1 0 1 0 0 1 0 0 0 0 0 0 0 0 1 0 0 0 0 1 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 1 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