Latest In Tech

I’ve been trying to pick-up a little oracle db experience. In Oracle sqlplus, if you type ed or edit at the command prompt, sqlplus will put the last command into an editor buffer for easy editing. Here’s a quick tip for you; the default editor in Oracle sqlplus can be changed to vim pretty quickly.

Here’s what you do:
1. Create the file login.sql, with any editor, in your home directory
2. Add the line “DEFINE _EDITOR=vim” to the file login.sql

From now on typing the command “ed” in to Oracle sqlplus will open the buffer with vim.