using the anydata datatype in oracle
——————————————————————————– — sys.anydata.sql ——————————————————————————– — Using the ANYDATA object — Startin with Oracl9i and up, ANYDATA is described — by […]
——————————————————————————– — sys.anydata.sql ——————————————————————————– — Using the ANYDATA object — Startin with Oracl9i and up, ANYDATA is described — by […]
Target: Oracle Report should generate > 13000 pages of PDF output. This is a long running report around 15 Minutes.
Dynamically changing a Oracle Forms Item from “normal” to bold: SET_ITEM_PROPERTY(‘block.item’, FONT_WEIGHT, FONT_BOLD); SET_ITEM_PROPERTY(‘block.item’, CURRENT_ROW_FONT_WEIGHT, FONT_BOLD); That’s it.
Let’s think we write a select statement and would like to DECODE (on Oracle database) on a column: DECODE(bew.bewart_tid, ‘GDL’,
You have a simple sql statement like this: select machine, count(*) as users from v$session group by machine This query
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’, ‘ ‘)))