Sql ed wrote file afiedt.buf

If you are using Notepad under Windows, you do this by going to the File menu and choosing Exit. Be sure to save the file before leaving the editor. Most editors, including Notepad, will remind you to save your changes before you exit, but vi will not. You should explicitly save your changes unless you want to throw them away.

The contents of the work file are loaded into the buffer and displayed on the screen for you to see. The work file afiedt. Its contents remain undisturbed until your next use of the EDIT command. Previous page. Table of content. Next page. Table of contents: Beware of ed! Editing Specific Files. History of Afiedt. Buf First a little bit of background information on the odd name.

When the editor wanted to bring up a file for editing, the file had to be given a name unique enough so as not to conflict with anything else. Therefore the file was named ufiedt. However an operating system that Oracle supported couldn't handle a 7 character file name before the period before suffix.

Therefore the name was shortened to afiedt. As the advancements in technology came, Oracle didn't bother to change it and the name stuck. Long live afiedt. Why Change It? If ain't broken, don't fix it.

Shouldn't that be the case? When that happens, just press Ctrl-D. There is the potential for conflict if you and another user happen to be sharing the same current working directory, and you both invoke an external editor to edit the contents of your SQL buffer.

After all, only one afiedt. The original statement was not changed in the external editor. The result statement, which only appears to be an edited version of the first, is a statement I edited in another window.

I used the following sequence of events to generate this example:. Of course, on Windows you usually have only one user per system, so this scenario is unlikely. However, it's common to have many concurrent users on Linux and Unix systems, so the possibility of this scenario is something you should remember. However, the vim editor can't determine whether two users are trying to edit the same file, or whether the swap file is left over from a previous editing session that crashed.

Another use for the EDIT command is to edit an existing text file. You can edit any text file you like whether it contains a query or not. When you edit a file in this way, the contents of the file are not loaded into the buffer. Take another look at Figure Find centralized, trusted content and collaborate around the technologies you use most.

Connect and share knowledge within a single location that is structured and easy to search. This is a very simple question that I can't find the answer to. I am in sqlplus Oracle and I made a typo and typed "edit" which opens up "afiedt. Once I am in the editor I get "Wrote file afiedt.

Then I would like to see what the contents of the file is. When I type anything, I get a "? Once I get the "? How can I exit out and see the contents of the file. I also tried "wq" and "! Neither of these commands worked. I would like to be able to edit the file once I have made an error and not type it over.