Sql Statement – SERPland

PL/SQL: Merge Statement – Merge into a single table (no Join to insert or update) – like mySQL upsert

admin / 05. October 2008

On Oracle, you can write simple insert/update statements with PL/SQL. Also using some if-then-else cases you can decide wether to […]

admin / 13. December 2006

Let’s think we write a select statement and would like to DECODE (on Oracle database) on a column: DECODE(bew.bewart_tid, ‘GDL’,

admin / 23. November 2006

You have a simple sql statement like this: select machine, count(*) as users from v$session group by machine This query

admin / 17. October 2006

Enable SQL Trace for my own single session: ALTER SESSION SET SQL_TRACE = TRUE; Or use a pl/sql program instead: