My take on a query to list historical SQL statements. Play around with the where clause to change this to your needs.
Either run this query as sys/system, or give the user this privilege:
Note that you can only select from v$sql; you cannot grant to v$sql or any other fixed views. So here we need to give the grant directly to the base table v_$sql instead.
The Dynamic Action in the Code section below is included as an example of how to get Codemirror to work in reports - more info on my Codemirror
page. It is not needed for the rest of this example, but it does make it look nice.