Merge two fields for easy view .
Hello Gurus.
I recently had the need create an user friendly view merging two fields on dba_audit_trail, sql_bind and sql_text.
Follow example:
SELECT sql_bind ,sql_text FROM DBA_AUDIT_TRAIL;
#1(3):100 , UPDATE PROCESSO_TESTE SET PROC_ID=:custid where PROC_ID=251
transforming in:
SELECT easy_sql_read FROM view or table or other objects for solve this;
UPDATE PROCESSO_TESTE SET PROC_ID=100 where PROC_ID=251
Any idea for help me???
Regards Paulo
0