Skip to content
This repository was archived by the owner on Mar 12, 2020. It is now read-only.
This repository was archived by the owner on Mar 12, 2020. It is now read-only.

"before" Argument #6

@Neospiro

Description

@Neospiro
  • oracle show the prompt :

    SQL> SQL> SQL> SQL> SQL> 2

I know solution is here :

set sqlprompt ''

I would like to setup the before argument defined in SQLTools/blob/master/sgbd/oracle.settings in my sublime-settings

If you want, here is settings for Oracle 🎁

  SET LONG          100
  SET PAGESIZE      0 EMBEDDED ON
  SET LINESIZE      32767
  SET HEADING       ON
  SET TRIMSPOOL     OFF
  SET WRAP          OFF
  SET COLSEP        |
  SET SQLBLANKLINES ON
  SET FEED          ON
  SET NULL          @
  SET VERIFY        OFF
  SET SERVEROUTPUT  ON
  SET TAB           OFF
  SET AUTO          ON
  SET TI            OFF
  SET TIMI          OFF
  SET UND           '-'

Commented :

  SET LONG          100 --big 'long' numbers
  SET PAGESIZE      0 EMBEDDED ON --header 1 time per query
  SET LINESIZE      32767 --very no wrapping
  SET HEADING       ON --headers
  SET TRIMSPOOL     OFF --no trim
  SET WRAP          OFF --no wrap
  SET COLSEP        | --column separator
  SET SQLBLANKLINES ON --accept blank line in queries
  SET FEED          ON --show number of line returned
  SET NULL          @ --@=null ; better than empty
  SET VERIFY        OFF --don't show the substitution debug output
  SET SERVEROUTPUT  ON --show the dbms_output outputs
  SET TAB           OFF -- don't use tab for multiple spaces
  SET AUTO          ON -- accept autocommit (very dangerous)
  SET TI            OFF -- doesn't show time
  SET TIMI          OFF -- doesn't show execution time
  SET UND           '-' --header underline

Thank you 👍

Do you prefer multiples issues feedback or one big ?

Metadata

Metadata

Assignees

Projects

No projects

Milestone

No milestone

Relationships

None yet

Development

No branches or pull requests

Issue actions