Oracle 8i OCI samples contain pretty SQL console. It is much better than standard SQL*Plus. It has history buffer for SQL statements and convinient line edit capabilities. After some modifications long NUMBER support was added (for numbers those can't be fit in float or int values).

It is useful to set large Screen Buffer for this application in order to avoid long line wrapping.
This version uses Oracle 7 OCI interface. It requires path to OCI.DLL to be added to PATH Environment Variable. Usually, this library is located in <Oracle installation path>\bin.

• Console scroll buffer size is set to 800x800 on start.
• SELECT results can be viewed page by page or breaked by Esc. Results paging can be enabled or disabled by /page and /nopage) commands. By default paging mode is enabled.
• Output of SELECT's can be completely disabled by /noout. It is useful when executing SQL statements from file, because output degrade system performance. Output can be re-enabled by /out.
• You can execute SQL statements from file <filename> by typing the following:
  @<filename>
• reconnect can be performed by /connect
• exit from console - /quit, /exit, /q

• Now asterisks are printed when you types a password, thanks to dashkaX@dashka.org.ua (remove X).
• Command prompt features are added. You can specify username, password and service name to use for Oracle connection. You can also specify path to file with SQL statements to execute.
• Sources are published (they are ugly a little...): oconsole_v1b_src.rar/tgz (7.5 Kb/7.6 Kb)

    oconsole [user:<username>] [pwd:<password>]
                 [[svc|service]:<service name> [@<sql-filename>]
    defaults:
      username     system
      password     manager
      service      <empty string>

• Fixed bug with new lines when entering logig/password.
• Added feature for entering code for TRIGGERs, FUNCTIONs and PROCEDUREs. Now terminating character is "\", like in SQL*Plus.

• Fixed bug with GRANT CREATE TRIGGER/FUNCTION/PROCEDURE. It was interpreted as simply CREATE TRIGGER/FUNCTION/PROCEDURE.
• Variables like :new in TRIGGER', FUNCTION's and PROCEDURE's sources are not treated anymore as bindable variables. User will not be prompted for enter value for :new.

FB