Recovering SQL Editor Files (Queries, Procedures) After Toad For Oracle Crashes or Hangs

  • Post author:
  • Post category:PLSQL / SQL
  • Reading time:2 mins read
You are working in SQL editor of TOAD and writing a large query or program and suddenly Toad hangs due some abnormal execution or other reason and you have not saved your work then it is a bit worry situation because you want to save your huge query or program in which you was working.
If this happen then don't worry just kill that session of TOAD and restart the toad and most likely Toad will prompt you to recover your most recent SQL editor file by displaying following window:
But if Toad does not display this window or you skipped then you recall this window by using following steps:
1. Go to File menu and click on the Recover Documents... option as shown below:

2. Then select your SQL editor file in which you recently worked, that's all.

Vinish Kapoor

An Oracle Apex Consultant, Oracle ACE, and founder of and a question and answer forum for developers.