Generating SQL Statements from FGA
I want to generate sql statements by using columns lsqltext and lsqlbind of table sys.fga_log$ while audit trail is DBMS_FGA.DB + DBMS_FGA.EXTENDED . I actually generate sql statements by replacing bind variables used in lsqltext with the values of bind variables in lsqlbind columns. I execute that sql statement on another db. Problem is that where there comes date column. Format of date changes in lsqlbind column , some time it captures date like '07-JUN-22 12.32.52 PM' , '07-JUN-22 12.32.52.107000000' and '8/12/2022 0:0:0' . I want uniform date format like '8/12/2022 0:0:0'.