Mostly I've had it fairly easy in my career. When I worked in the UK, I just had the one time zone to work with. The only time things got complicated was when I was working at one of the power generation companies, and we had to make (more...)
- Performance since PostgreSQL 7.4 / pgbench: mit dem schönen Fazit "The newer the PostgreSQL release, the better the performance. Yay!" Darüber hinaus gibt es noch folgende Einsichten:
- "some releases make a huge improvement"
- "Older releases perform (more...)
The business analyst or QA wants to check all the help texts for all items in your apex application – don’t force them to navigate to each page and click on the labels, one by one; instead, give them a spreadsheet to review at their leisure.
Method 1: use the apex data dictionary viewer
1. Open your application in the Apex application builder
2. Utilities -> Application Express Views
3. Choose APEX Application Page Items
- select lpad(x,2000,x) from DEMO;
- 683 consistent gets
- 20163693 bytes sent via SQL*Net to client
- 668 SQL*Net roundtrips to/from client
- 35 consistent gets
- 118324 bytes sent (more...)
It’s that time of year again – for the ODTUG Editor’s Choice Awards. This year we welcome submissions in all media – even online annotated demos. Shows us your stuff – wow us with your brilliance and clever use of Oracle development tools! Hello, ODTUG! Spring is here – finally…
Since then, I tried to get information on this topic. After a few emails I got the info I needed.
I hope that this cools down the rumor mill a little bit.
with dates as ( select trunc(sysdate, 'year') + level - 1 as day from dual connect by extract(year from trunc(sysdate, 'year') + level - 1) = extract(year from trunc(sysdate, 'year')) ), timezones as ( select vtn.TZNAME, listagg(vtn.TZABBREV, ', ') within group(order by vtn.tzabbrev) tzabbrevs from v$timezone_names vtn group by vtn.TZNAME ), offsets as ( select v.*, d. (more...)
The following SQL statements are all clues to the names of trees:
--#1 select covering from mammals; --#2 update wood set state = 'burnt'; --#3 select admiration from people minus select name from pronouns where type = 'second person'; --#4 select target from diseases where nationality = 'Dutch'; --#5 update oslo set appearance = 'smarter'; --#6 select * from elements e join punishments p where e.atomic_number = 47 and p. (more...)
- einmal in jeder Sekunde werden die Informationen zu aktiven Sessions (state = 'ACTIVE') aus v$session nach v$active_session_history kopiert.
- diese Snapshots werden als Sample bezeichnet.
- ein Zehntel dieser Datensätze wird in der entsprechenden AWR-Tabelle dba_hist_active_sess_history persistiert.
- Es handelt sich aber nicht um jeden zehnten Datensatz, sondern um die Datensätze der zehnten Sekunde. Im Ergebnis sieht die enthält die AWR-Tabelle also einen (more...)
|Ookla Speed Test Result|
The upload speed is no doubt way too slow to cater for voice and screencast. Unfortunately I also seem to be in quite the dead spot for 4G wireless connection.
Download speed might be enough to support the streaming services recently launched in Australia, but I know ABC's iView does stutter occasionally so I think I'll still have to wait (more...)
Oracle allows for a maximum of 30 Bytes when naming objects like users, tables, ...
When it comes to migrating objects to Oracle, SQL Developer will truncate the object names and resolve clashes with unique names.
Say for example you have two tables called
Oracle SQL Developer will convert these to
Since some time I have been adding
WHERE 1=1 to all my queries.
I get queries like this:
SELECT * FROM emp e WHERE 1=1 AND e.ename LIKE 'A%' AND e.deptno = 20
Lots of people ask me what’s the use of this
You know I like to type as little as possible but here I am typing a lot of extra characters. And yet, it makes my development life a (more...)