Hi guys, its realy a problem when you lose unsaved code. For about a month I have been working on a big procedure, and forgot to save the code in SVN. If you read this and remember have such unsaved code, commit it immediately! :) Because everything could happen with your test db. Ok. you're lucky if you were using Oracle SQL Developer, because this program has a great feature - it saves your code in its sql history inspite of eating a big party of your RAM. Open your file explorer and locate this folder:
You'll find a lot of xml files, and if you're twice lucky, you'll find your lost code. Its wonderful. :) .
If you're using another program, try to find feature like this and maybe it helps you. My condolences if this post doesn't help you, in any case, try to find something good among the next:
1) write your code again, and it will be better than before as you did it once
2) commit your code, so you'll not face such problem in the future
3) tell your friend a story for a beer :)