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

SQLPlus

by bofm ST3

Sublime Text 3 plugin for Oracle Database SQL*Plus.

Labels language syntax

Details

Installs

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