SQL Trace with Oracle Database
Enable SQL Trace for my own single session: ALTER SESSION SET SQL_TRACE = TRUE; Or use a pl/sql program instead: […]
Enable SQL Trace for my own single session: ALTER SESSION SET SQL_TRACE = TRUE; Or use a pl/sql program instead: […]
Remove: select TRANSLATE(’12A3′,‘0123456789’, ‘ ‘) FROM dual or select LTRIM(RTRIM(TRANSLATE(UPPER(’12a’), ABCDEFGHIJKLMNOPQRSTUVWXYZ’, ‘ ‘))) as nr , LTRIM(RTRIM(TRANSLATE(UPPER(’12a’),‘0123456789’, ‘ ‘)))