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 9K
  • Mac 2K
  • Linux 1K
Jun 5 Jun 4 Jun 3 Jun 2 Jun 1 May 31 May 30 May 29 May 28 May 27 May 26 May 25 May 24 May 23 May 22 May 21 May 20 May 19 May 18 May 17 May 16 May 15 May 14 May 13 May 12 May 11 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
Windows 0 2 0 0 0 0 0 1 0 0 1 0 1 1 0 0 1 0 0 0 0 0 2 1 1 0 1 0 0 0 0 2 0 0 1 0 2 0 0 0 1 0 1 1 1
Mac 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 0 0 2 1 0 0 0 0 0 0 0 1 1 0 0 0 2 0 0
Linux 0 0 0 0 0 0 0 0 1 0 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 0 0 1 0 0 0 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 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