Thursday, July 16, 2009

sqlplus tip

1. DEFINE_EDITOR=vi  - define the vi editor
2. EDIT - edit the sql statement in current buffer with using vi editor
3. save file <filename> - save the sql statement in current buffer to a file
4. get file <filename> - load the sql statement from file to current buffer
5. / - execute the sql statement in current buffer

No comments: