How to get details of SQLs executed from PL-SQL code?

EXECUTE DBMS_TRACE.SET_PLSQL_TRACE(37);
<< YOUR STATEMENT >>
EXECUTE DBMS_TRACE.CLEAR_PLSQL_TRACE;

Then query following tables :-

sys.plsql_trace_runs
sys.plsql_trace_events
sys.plsql_trace_runnumber