Database Security Products (MOSC)

MOSC Banner

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'.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center