Re: VI in SQLPLUS: still the same mess.

From: HansF <News.Hans_at_telus.net>
Date: Mon, 23 Jan 2006 15:23:06 GMT
Message-Id: <pan.2006.01.23.15.23.01.942542@telus.net>

Oh great visionary crystal ball, please help us understand the problem for this lost soul.

As this innocent life form can not speak for himself to guide us into the unknown, we beg thee to tell us the answer to these hidden questions: what are the operating system and database version he is using?

Then and only then might we have a clue to the directions we need to look to help this one into the light.

In the mean time, let us expend valuable energies, perhaps uselessly, with an example ...

poppa_at_fuzzy:~> whereis vi
vi: /bin/vi /usr/bin/vi /usr/share/man/man1/vi.1.gz /usr/share/man/man1p/vi.1p.gz pop2_at_fuzzy:~> uname -a
Linux fuzzy 2.6.11.4-21.10-default #1 Tue Nov 29 14:32:49 UTC 2005 i686 i686 i386 GNU/Linux poppa_at_fuzzy:~> sqlplus hr/hr

SQL*Plus: Release 10.2.0.1.0 - Beta on Mon Jan 23 08:14:35 2006

Copyright (c) 1982, 2005, Oracle. All rights reserved.

Connected to:
Oracle Database 10g Express Edition Release 10.2.0.1.0 - Beta

SQL> define _editor=/usr/bin/vi

SQL> !ls test.sql
ls: test.sql: No such file or directory

SQL> edit test.sql
[goes into full screen vi mode]

select * from dual;
~
~
~
~
~

-- INSERT --                                                  1,20          All

ESC
ZZ
SQL> !ls test.sql
test.sql

SQL> @test

DUM

---
X


-- 
Hans Forbrich                           
Canada-wide Oracle training and consulting
mailto: Fuzzy.GreyBeard_at_gmail.com   
*** Top posting [replies] guarantees I won't respond. ***

Received on Mon Jan 23 2006 - 09:23:06 CST