Important Notice: Our web hosting provider recently started charging us for additional visits, which was unexpected. In response, we're seeking donations. Depending on the situation, we may explore different monetization options for our Community and Expert Contributors. It's crucial to provide more returns for their expertise and offer more Expert Validated Answers or AI Validated Answers. Learn more about our hosting issue here.

How can I use DTM SQL editor as the external editor for Oracle SQL*Plus ?

April 26, 2017DTM editor external Oracle sql

0

Posted

How can I use DTM SQL editor as the external editor for Oracle SQL*Plus ?

1 Answer

0

Posted

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=, 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=, 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 ve