Re: Substitution Variables

I assume this is for ad hoc work (not something made for users) in which case it's prety easy to modify the actual statement. Either use Modify or Use editor to do that. Of course that is a little more tedious if you want to run a lot of statements with different values. The best solution is however to do it all from your MS Windows PC (you do have one, don't you?) and use MS Access. There you have such prompting facilities and a lot of other options lacking in dbaccess. Much better tool for ad hoc querying of databases. On Wed, 22 Apr 1998 17:34:40 +0200, Robertson Lee NTSE <Lee.Robertson@nts.hl.siemens.de> wrote: > >Hi, > >Apologies for mentioning the dreaded O word but I am an Oracle DBA and >when I need to be prompted for a variable when running some SQL in an >sqlplus session I use an '&' character. Is there anything similar to use >within dbaccess to achieve the same results. I am using Online 7.23 UC4 >on HP-UX 10.01 > >Regards > >Lee Robertson > >Lee Robertson >Oracle DBA >Siemens Microelectronics Ltd >Tel 0191-2804037 Nils Myklebust NM Data AS Norway E-mail: Nils.Myklebust@nmdata.com FAQ at: http://www.iiug.org/techinfo/faq/faq_top.html (Now with ODBC info under "Third party products".)