simple question, please help...

[softdrink]

When I type a statement and make a mistake, is there a way to retrieve the statement or do I have to retype it again. Sometimes I make a long statement and make a stupid mistake, and then need to retype the whole statement.

thanks,

softdrink

 

[EdWall]

If you are using SQLPlus, you can type ed to use the system editor which is dependent on the Operating System e.g. Notepad.

You don't say whether you are using SQLPlus

 

[softdrink]

Yes,I'm using SQLPlus.

softdrink

 

[JJSmith]

Editors need to be configured and may not always be available.

l = list current statement ( as a numbered list )

<num> = put line <num> in context ( when listing line has an * )

c/old/new/ = change old string to new string on line in context.

a str = append str on the end of line in context

i = insert new line after line in context ( ctrl c to stop inserting )

del = delete line in context

hope this helps
JJ_Smith_@hotmail.com