|
Frequently Asked Questions
Q: How can I use DTM SQL editor as the external editor for
Oracle SQL*Plus ?
A: There are two options:
permanent use and single session use. If you choose the permanent use mode, you
should create or edit login.sql file in the home directory of SQL*Plus (D:\ORANT\BIN)
and insert the following line: DEFINE _EDITOR=<program path>, see below
for reference.
WARNING: in the case when the
path has spaces, put it into quotation marks; see the second figure.
If you choose the single session use
mode, just type DEFINE _EDITOR=<program path>,
for example:
DEFINE_EDITOR=C:\Program Files\SQLedit.exe
Another way is to select Editor/Define
Editor item in "Edit" menu and to type the program path in the dialog box.
Q: What is the easiest way to place query results into MS Excel
spreadsheet format?
A: Right click over the page with the results and select "Export".
Select "Excel" as your export format.
Q: Are there easy ways to publish the results on the Web?
A: Use HTML export feature.
Right click over the page with the results and select "Export". The program
saves data in the very basic format, so we recommend you to employ some more
powerful HTML authoring tool to edit the data afterwards.
Q: I usually acquire data from several data sources at a time.
How could I know which data source I'm connected to?
A: Starting from the version 1.00.84, the program displays the
name of the current data source you are connected to, user name and the name of
the data scheme in the window title in "DSN/user/owner/database" format. If some of these
fields are empty, they are not displayed, but separating '/'s remain.
Tips. Did you know...
You can get quick access to the file or script you edited earlier by using drop-down
menues near Load and Run toolbar buttons.
You can use macros to automate entering scenarios.
You can use right mouse button to get access to the context menu in SQL editor or results viewer.
You can select rows, columns or set of cells in the results grid using left mouse button and drag.
You can view Binary Large Objects as binary or as hexadecimal. View "Settings"
for more details...
Program can visualize NULL data values as empty strings or as "NULL" strings.
See program options for detailed information...
You can view current cursor position at the right side of the SQL Editor status bar.
Program always creates backup (.BAK) file in the same directory to avoid data overwriting.
Program always creates "auto-save" file for the current script before running it to prevent data loss.
|
