jQGrid Integration Kit for PL/SQL and Apex version 1.2 available

It’s been over two years since I released the initial version of the jQGrid Integration Kit for PL/SQL and Apex.Since then, I’ve added some additional features and fixed a few bugs:Version 1.1Procedure include_static_files_once will make sure required …

Never Ever Do That

| May 21, 2012 11:11 +0000

ALTER TABLE sys.dual ADD (dummy2 VARCHAR2(1));

Tom Kyte:

You never, never never never, as in never ever – touch any of the SYS tables – not to insert into them, not to delete from them, not to update them and especially not to alter them.


R…

The Oracle Cloud Cookbook

| May 21, 2012 06:30 +0000

By Roddy Rodstein:

The Infrastructure as a Service (IaaS) chapters review how to plan, design, deploy and support Oracle VM for x86 with Oracle Linux, Solaris, and Windows virtual machines Managed by Oracle VM Manager and Oracle Enterprise Manager. Th…

Mental failings: overblown risks

| May 21, 2012 03:00 +0000

 

Much Ado About Nothing?

| May 21, 2012 02:59 +0000

I was reading this presentation PDF of Hugh Darwen recently, called How To Handle Missing Information Without Using NULL. Several great thinkers and founders of the relational theory consider NULL as the thing that should not be. For example, one slide…

Conference "Future of Oracle Forms"

| May 21, 2012 02:35 +0000

I got an invitation to an interesting conference in the netherlands next week (May 15th 2012).AMIS in the netherlands is the initiator of the conference and host, too.The conference is splitted into two parts. From 9 to 5 we will hear many presentation…

★ 11 Interesting Things You May Have Missed This Week

| May 20, 2012 07:00 +0000

What Type of Business Conference Cliché Are You?

Here is how you can learn #Oracle ADF online

#Oracle 11gR2 RAC Quick Reference

All you need to know (and more) about #Oracle Database 11g Release 2 is on this Portal

The Permissions Your Database U…

Code Comments Gone Wrong

| May 19, 2012 21:15 +0000

Dimitrios Kalogirou offers good advice:

Write self descriptive code ! Your code should be read like sentences. Avoid smart shortcuts and tricks because they break the reading… I use code comments when the code is not really self documenting. Comment…

Advisor Webcast Inter-window Communication (IWC)

On May 15 Oracle held an Advisor Webcast on Inter-window Communication. In my opinion one the most exciting features added in PeopleTools 8.52. IWC makes it possible to have Pagelets communicate with each other on homepages, dashboards, workcenters and…

Microgen DBClarity Developer: Introductions

| May 18, 2012 09:07 +0000

Got a minute or two to spare and still not quite sure where DBClarity Developer fits in? Watch the brief introduction video posted on our website: http://www.microgen.com/uk-en/products/microgen-dbclarity-developer.

Broken jobs

| May 18, 2012 00:00 +0000

Work is Killing You and 10 Ways to Stop It From Happening!

This has been a hot button for me for some time – if we don’t find a way to fit exercise, fitness, and some healthy eating into our sedentary lives (like we in IT tend have), we will not live as long as we hope. And life will not be as enjoyable as…

Thursday Thought – Busy busy busy

| May 17, 2012 05:50 +0000

Over the next month or so, my posts may slow down a touch.One exciting reason involves this little device pictured. I won’t let too much out of the bag just yet, but an opportunity presented itself and I just had to take it.This means I need to start p…

An article suggestion from PacktPub.com

| May 17, 2012 05:23 +0000

Dear All All Packt publishers have extracted a chapter of my book as an article. PL/SQL: Using Collections The Oracle Advanced PL/SQL Developer Professional Guide helps you master advanced PL/SQL concepts. Besides the clear and precise explanation on a…

More fun with dates

| May 16, 2012 16:08 +0000

Last week I had a post reminding us to consider the time component of our date data types.Here I’m just listing some fun with dates, either from single row sql expressions or cool little queries.select sysdate today ,trunc(sysdate) midnight_today ,tr…

Organizational Culture and the influence on Enterprise Architecture

When looking into the topic of Enterprise Architecture it’s a common mistake that it is only about the rational element of change within an organisation. Enterprise culture and the will to change cannot be forgotten in the equation.
The past few we…

The fastest update in the west

| May 16, 2012 00:00 +0000

Oracle PIVOT

| May 15, 2012 18:00 +0000

A common requirement for queries is to turn rows into columns, or the other way around.In Excel, we can do this using TRANSPOSE, a bit of patience & know-how, and ctrl+shift+enter.In Oracle, if we have aggregate data displaying months by row, the o…

SOA Maturity Models

The past few weeks we’ve been talking about Service-Oriented Architecture and Maturity. But how do we do assessments to measure the maturity? What models are there that we can use. In a presentation I will talk about two major models that are here t…

DBClarity Webinar – Reusing SQL Queries

| May 14, 2012 09:19 +0000

In my last entry I said that I'd watched Tristan's webinar on reusing a SQL query to create insert and merge statements. I enjoyed the re-usability aspect, so quickly created a video to show the feature, not having the patience to wait for Tr…