SQLRunner Usage

  • Common usage

    This shows you how to connect to a database.

  • Working with SQL and retrieved data

    SQLRunner provides a couple of features to work with data.
    * Run single statement as well as scripts and loading scripts with start or @ command (like Oracle SQLPlus)
    * Edit cells comfurtable
    * Create new datasets
    * Delete one or mulitple datasets at once
    * Sum and count content of all or selected rows in a column
    * Copy&Paste selected rows and columns into the clipboard as tab delimited text
    * Navigating over imported and exported keys to referenced and referencing datasets

  • Compare schemas

    Supported (optional) by a growing number of customized database vendor specific modules SQL offeres the possibily to compare schemas.

  • Export Data

    Export features are:
    * Export the current retrieved datasets from the result table
    * Export a query
    * Export a couple of tables as XML

  • Import data from files

    This lesson describes how to import files into tables. You can import data from XLS, XLSX and CSV files.

  • Helper tools

    Useful small tools to do side-line tasks.

  • Preferences