RE: how can i set an editor in oracle for writing quer...
Hi,
To set the editor for editing sql commands and PL/SQL code at the SQL*Plus (Unix: $sqlplus) enter the following command at ur sql prompt after logging in
define _editor = <path and file name of the exe for the new editor>