Beefy Boxes and Bandwidth Generously Provided by pair Networks
good chemistry is complicated,
and a little bit messy -LW

RE: Editor tricks.

by runrig (Abbot)
on Sep 29, 2000 at 22:53 UTC ( #34670=note: print w/replies, xml ) Need Help??

in reply to Editor tricks.

My favorite thing with vi is that I've set up the F1 and F3 keys so that if I have a block like this:
select something
from sometable
where something="some_value"

If I hit F1 while in the block, it pipes the contents of the block to sqlplus (Oracle SQL tool, it used to go to dbaccess, the Informix SQL tool), and creates a block below the current block with the results. That way I can edit any sql with vi, and all queries and results are immediately saved (temporarily at least in the current vi session).

I have F3 set up to delete the block after the current block, so it makes for quick edit/execute/edit/execute cycles until I like the result.

On any WinPC I'm forced to use, I usually install vim, because I can't stand Notepad. Though I've never implemented the above sort of system from a PC.

Log In?

What's my password?
Create A New User
Node Status?
node history
Node Type: note [id://34670]
and the web crawler heard nothing...

How do I use this? | Other CB clients
Other Users?
Others musing on the Monastery: (6)
As of 2020-06-03 09:42 GMT
Find Nodes?
    Voting Booth?
    Do you really want to know if there is extraterrestrial life?

    Results (22 votes). Check out past polls.