How can i set an editor in oracle for writing queries/pl/sql code?

Questions by haisubbu

Showing Answers 1 - 3 of 3 Answers

sand

  • Feb 28th, 2006
 

Just type in ed

  Was this answer useful?  Yes

Guna Sagar Challa

  • Mar 27th, 2006
 

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>

Hope this solves ur prob

Cheers,

Guna Sagar Challa

  Was this answer useful?  Yes

jagadishVarodia

  • Apr 12th, 2006
 

For time being type below command at sql prompt

SQL>define_editor=vi

You can add export EDITOR=vi in .profile and logou/login for permament change

Hope this will solve it

  Was this answer useful?  Yes

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.

 

Related Answered Questions

 

Related Open Questions