oracle-databaseoracle12ctoad

Does TOAD for oracle generate logs of executed SQL?

I cannot seem to find a view which I created in one of my schemas within TOAD. Lets assume I don't know the exact schema in which I've created it, is there any way where I can find all the create statements which have been executed within a period of time, lets say the last days.

Thank you in advance.

Solution

  • You might be looking for a feature called "SQL Recall" in Toad. Press F8 or View/SQL Recall. It will show you the last 500 (by default) queries you ran.