> I agree.
>
> It was early when I answered, I was grumpy (still am since coffee's not
> kicked in yet), and was deliberately being obtuse, as OP did not provide
> the environment. (Which seems to be a growing epidemic - again.)
>
> Of course, to answer the OP's question, there are a number of ways, but
> some are OS dependent. Howard has shown a beauty at dizwell.com, but
> (iirc) it's for command-line Sqlplus in Windows.
>
> And, of course, there is the little known (and very limited) native editor.
> I'm always amused at the reaction ("I didn't know you could do that")
> when I correct my sql directly like
>
> pop2_at_fuzzy:~> sqlplus hr/hr
>
> SQL*Plus: Release 10.2.0.1.0 - Beta on Mon Jan 23 09:26: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> select usernm
> 2 from user_objects
> 3
> SQL> i
> 3 wherte object_name like 'C%'
> 4
> SQL> 1
> 1* select usernm
> SQL> c/nm/name, object_name
> 1* select username, object_name
> SQL> l
> 1 select username, object_name
> 2 from user_objects
> 3* wherte object_name like 'C%'
> SQL> c/rt/r
> 3* where object_name like 'C%'
> SQL> l
> 1 select username, object_name
> 2 from user_objects
> 3* where object_name like 'C%'
> SQL> c/username
> 1* select , object_name
> SQL> c/,
> 1* select object_name
> SQL> l
> 1 select object_name
> 2 from user_objects
> 3* where object_name like 'C%'
> SQL> /
>
> OBJECT_NAME
> --------------------------------------------------------------------------------
> COUNTRIES
> COUNTRY_C_ID_PK
>
> SQL>
>
>
> Painful, yes. But it has it's uses. <g>
>
> Then there are tips like http://vim.sourceforge.net/tips/tip.php?tip_id=41
>
> And iSQLPlus.
>
> And, of course, Raptor - which pretty much nullifies the question
> entirely. I can't wait until it's production.
>
Pretty painfull, yes :-) But actually, it's really approaching what I
was looking for. By the way, I reckon I didn't understand at all the
use of "define _editor=vi".
THanks for your answer.
Received on Thu Jan 26 2006 - 07:08:28 CST
