SQL Language (MOSC)

MOSC Banner

Merge two fields for easy view .

edited Oct 30, 2012 3:18AM in SQL Language (MOSC) 9 commentsAnswered ✓
 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

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