Re: DBA*SQL question

>==========Tassos Anastasiou, 6/20/95==========
>I just started using sqldba and I have noticed that unlike SQLPLUS,
>it is not possible to edit the current SQL command in that environment.
>In other words, if I type a long sql query in sqldba and I make a mistake,
>I have to retype the whole query again in order to correct the problem.
>My question: is there a way I can edit a query in sqldba without
>retyping the whole thing?
 

>Thanks

 -
>Tassos Anastasiou Frame Technology Corp.

First, I usually recommend using SQL*DBA only for dba activities. You are logged into ORACLE essentially as SYS and can do a lot of damage with the wrong SQL command.

As to your question, I just HOST out to the OS, use my favorite editor to create/edit a SQL script then exit back into SQL*DBA to execute it. A few extra key strokes but it beats re-entering the whole script each time.

Hope this helps.

Jim Gregory Received on Thu Jun 22 1995 - 00:00:00 CEST