>>>>In using Oracle's SQL*PLUS, is there any way to have the last several commands typed to reappear or does one have to always retype things?
>>>>SQL>
>>>
>>>You can copy and paste in the sql window.
>>>For selects the 'l' key lists the previous select and you can change any part of it with the 'c' key. For instance the list might return...
>>>
>>>1. select * from db
>>>2. where field1 > 10 ;
>>>
>>>you can then type l2 (list line 2)
>>>and change c/10/5/ to change 10 to 100
>>>
>>>type '/' to rerun the sql
>>>'l' list would return
>>>
>>>1. select * from db
>>>2. where field1 > 5 ;
>>
>>I see, but even this seems basic and takes me back about 10-15 years in terms of user friendliness. Is there another way? Have you seen foxpro's editable command window?
>
>I haven't seen anything as friendly as the command window in ANY tool. There are tools (SQL Programmer for one) that make access easier.
>
>What I do connecting to Oracle or Sybase (I do both) is create remote views in VFP. It's fast, easy and flexible. Use the command line approach vs. the design wizard. The only hurdle is getting the drivers installed, after that VFP works fine.
So you use foxpro to get around the 'unfriendliness' of SQL?
"Build a man a fire, and he's warm for a day.
Set a man on fire, and he's warm for the rest of his life."