Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Shaun E on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

editing last SQL statement in sqlplus -dos mode

Status
Not open for further replies.

lhugh

MIS
May 21, 2000
115
CA
in Windows, using the SQL plus, if you type ed, notepad will appear and you can edit your last SQL statement if you made a mistake

is there anything like that in Linux?

 
Yes, type ed and the 'editor' defined by EDITOR= environment variable will be invoked (default is 'ed').

For example, in your .bash_profile file set this variable like this:

export EDITOR=/bin/vi

----------------------------------------------------------------------------
The person who says it can't be done should not interrupt the person doing it. -- Chinese proverb
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top