>>>>>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?

The company I work for is replacing old fox2.6 with a 'buy' system. It's backend is Sybase on a UNIX server. If you've ever done SQL from unix... unbelievable. I use vfp views and do in seconds what the non-fox users do in HOURS. The users prefer the fox system. The reasons for the change are valid, but VFP to Sybase or Oracle would have been a much wiaser choice.