Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Edit sql query

vishal patelMar 11 2008 — edited Mar 11 2008
Hi
All,

I am using oracle 10g on AIX. I am connecting to the database using command line. Now i am writing query and I did mistake in typing now I want to modify that query without using the editing buffer.
for example, select * from emp1. and I want to execute with emp instead of emp1.
I know there is a command to modify the sql without using the sql buffer editor. there is something like c /string1 /string2 but i am not sure. can anybody tell me the command for the same.

Thanks,
Vishal
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Apr 8 2008
Added on Mar 11 2008
5 comments
676 views