OraNA :: Oracle News Aggregator

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 …

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…

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…

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…

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…

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…

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…

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…

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.

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…

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…

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…

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…

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…

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…

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…

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…