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 7K
  • Win 6K
  • OS X 1K
  • Linux 759
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 Jun 12 Jun 11 Jun 10 Jun 9 Jun 8 Jun 7 Jun 6 Jun 5 Jun 4 Jun 3
Windows 0 1 1 6 1 0 5 3 3 3 3 3 1 1 4 2 1 2 3 0 3 6 5 2 9 1 3 4 7 4 2 1 1 4 3 7 3 3 4 2 2 1 3 2 4 1
OS X 0 0 2 0 0 0 0 0 1 0 1 1 1 0 0 0 2 0 0 0 1 1 0 0 2 0 0 0 0 0 2 1 0 0 0 0 0 0 2 1 0 1 0 1 0 0
Linux 0 0 0 0 0 1 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 0 1 0 0 1 0 0 1 1 2 1 0 0 0 3

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